The value axis seems to have default formatting of "percentage". I made it a number and it's now coming out to 1, 1, 1, 1, 0. My numbers are in the hundreds...

When I run the macro shown below on a worksheet with columns of data (with column headings in row 1) I get some unusual results in Excel 2007 Beta 2...

Line graph for actual goal from January through August--the line graph for Sept-Dec follows the formula for August. I would like the line graph to stop at...

I've got a series of data on a line graph. It's nothing too rancy - dates and...

Hi All - I need to insert a 'dynamic' vertical line into a line-chart -- the line will separate the Past from the Future. After some searching, I found Jon...

My titles show up in the "Chart Options" menu. they are in black font on a grey background. They simple do not appear on my chart itself. I finally found...

Hi, I have a column diagram. The data labels are shown just below the X-axis for negative values. The problem is that when columns goes below x-axis they go...

I can't figure out how to plot the function as a graph? Where do I go? Charts seem to only work with data.

I have 6 categories which I am collecting monthly data on. I have a goal for each. I would like to create a bar/thermometer chart for each category, showing...

Hi can anyone help with these two questions. Windows 2000. Office 2002. Chart in Excel Question 1. When Y cooridinate is negative want X axis labels at bottom...

hi i have tried a few ways to alter the scale on the x axis of a scatter graph but so far not found a way to do it as i would like. my data point are at: 2...

I am an audiologist working for a London hospital and am interested in trying to computerise some of the analyses of tests we currently work out by hand. One...

Hi there, I want to do a comparion report for different vendors we are considering. Basically, there are four vendors and twenty-five criteria (cells) for...

I have a grid sheet that i need to type on left side horizonaly, and on top horizonaly, how is this done, thank you

I need to take an excel plot and print it 1:1 scale. I'm creating templates with the data plotted on the chart. The X axis is the larger scale, and varies...

How do I insert autodates into an Excel Spreadsheet?

In a workbook with multiple charts on multiple spreadsheets, the chart option to add a trendline is available on some of the charts and not on others - why? ...

I have created a chart but my data labels do not match the source data. The labels state, Series 1, Series 2, etc.

I have three variables that need to appear in my legend but only two of them should appear in the chart. How do I show the third variable in the legend...