Comparing Line Chart and Column Chart?

  • Thread starter Thread starter Nev.
  • Start date Start date
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
 
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/
_______
 
Back
Top