Comparing Line Chart and Column Chart?

N

Nev.

I have been using a line chart to display a set of individual results.

I now want compare with this, in the same display, a cumulative
sum of these individual results.

What is the simplest way to do this? A bar chart? Or?

Nev
 
J

Jon Peltier

Nev -

Assuming your individual data is in A2:A10, in B2 enter this formula:
=sum(A$2:A2) and copy it down to fill B2:B10. Make a line chart with
both columns of data. If you want you could change one series to a bar
type: select the series and choose Chart Type from the Chart menu.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Cannot see and gantt charts or other displays 0
Move Chart with Text 0
Creating a Chart on form from selected data in query. 0
Average bar charts with individual data points 2
Plot data from mutiple years on same chart 0
Odd Chart Format Results 1
Line and Bar on same chart 2
Bar Chart with Data Elements 1

Top