Plotting Cummulative Data In A Line Graph

T

tkeith

I need help figuring out how to plot cummulative data. I have product and
sales data in a table, broken down by quarter. For each product I want to use
a line graph to show cummulative sales over time.

For example, Product A has Q1 sales of $1M, Q2 of $1.5M, Q3 of $1.25M and Q4
of $1M. So the first point would be at 1M, #2 at 2.5M, #3 at 3.75 and # 4 at
4.75.

I can't find which format to use to make this kind of graph.
 
A

Andy Pope

Hi,

The chart will not do this itself. You need to use a helper column to
calculate the accumulated values and then plot those values.

Cheers
Andy
 
T

tkeith

I was afraid of that. Thanks.

Andy Pope said:
Hi,

The chart will not do this itself. You need to use a helper column to
calculate the accumulated values and then plot those values.

Cheers
Andy
 

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

Top