Plotting Cummulative Data In A Line Graph

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

tkeith - 08 Aug 2006 23:25 GMT

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.

Reply to this Message

Andy Pope - 09 Aug 2006 09:57 GMT

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

> 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
[quoted text clipped - 5 lines]
>
> I can't find which format to use to make this kind of graph.

Signature

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info

Reply to this Message

tkeith - 11 Aug 2006 01:36 GMT

I was afraid of that. Thanks.

> Hi,
>
[quoted text clipped - 13 lines]
> >
> > I can't find which format to use to make this kind of graph.

Reply to this Message