I'm trying to show the totals of two data series in a line chart. Everytime I inlude the cells in the data range the total cells are plotted in on the chart....

I use a spreadsheet to trend multiple elements by date. Auto-filter selects which element is charted. Some of the graphs (I have 6 graphs, each with...

If in one cell I enter date 12.6.2008., I need that the cell next to automaticly calculate date which is 60 days from that date (in this case it would be ...

Hi! I have two data series´, one i column A and one i column B. Column A consits of non numerical informatioon eg names of cities and column B consits of...

I have a stacked bar chart that I want to add 2 lines to. I can't seem to get this to work properly. Thanks -- DMM

Dear group, this question is concerning Excel 2003 on Win XP. A client sent me a chart-example, where he inserted an ellipse as an excel-shape on a...

Im am writing the scientific report where I have a calibration curve. I want to use that and find the concentration of an unknown sample. This is easily done...

How do I represent 2 different sets of values in one bar chart. For instance I want to compare two different years, with information showing 2 sets of...

Hello, I'm trying to create a report using VBA, and I think I've got it all down except for one step, and that is to add 35 blank lines between each of...

I have two sets of data, and have used the mean to make a column chart. I now need to add standard deviation error bars, which will be different for each...

I have various data labels in my basic column chart. The text direction is set to "rotate all text 270°". Everything looks fine until I re-open the...

I have a simple line chart with a data source in the same file on the previous worksheet labeled DATA. (Chart worksheet is labeled CHART.) Heres is a couple...

Hello, I want to make a graph which is based on a table which gets its data from other parts of my spreadsheet - so all the data is made from formulas. Some...

I would like to have Excel automatically exclude the series label on a stacked column chart if the value associated with it is zero. I can use the 0;0;;@...

I have 2 problems with a pie chart. The first is that my data is in columns and i can't seem to get the pie chart to work. I have the first column which is...

I am on Excel 2003 and need to create a simple pie chart. I am asked to put into the legend the data, individual dollar amounts and then the total in the...

How can I have the chart bars display the percentages and the data labels be the raw numbers? Is this possible?

I've got 62 charts in a single worksheet. I use VBA to create them. After they're created they look fine. Plot areas are all good. But when I copy the...

Among the benefits claimed for the Office 2007 service pack 2, due out between February and April is: ** Improved functionality in Excel’s charting...

In Office 2003 (v11.0) the "Format Chart Area" window has the "shadow" check box, but is missing the "Round corners" check box. Are there any suggestions for...