Plotting Cummulative Data In A Line Graph

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.

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

tkeith wrote:
> 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.

--

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

I was afraid of that. Thanks.

"Andy Pope" wrote:

> 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
>
> tkeith wrote:
> > 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.
>
> --
>
> Andy Pope, Microsoft MVP - Excel
> http://www.andypope.info
>