Adding a cumulative total to a chart

As this is column is at end only, so just include this column in table, but don't include this column in your graph range.

Hi,

Adding a Total column after the September columns and then plotting that on the column chart will make the other columns on the chart appear very small and therefore difficult to read/interpret.  You cannot shift the Total column to the secondary y axis either because that will shift Plan and/or Actual there as well.

My suggestion would be to first add another Total column for plan and actual after the September column and create a normal column chart.  Then right click on the Y axis values and under Format Data Series, select Logarithmic scale.

Hope this helps.

I have a line graph (and a bar graph - two separate charts). They both have the fiscal year plan for a project, and the actuals. They are displayed on the graph in a non-cumulative format.

On the bottom of the chart, is the little table with the numbers.

My manager just asked if I could add the cumulative total for the year to the end of the table. Can I do that without adding it to the graph and screwing it up?

You could add it, then right click on the new series, and edit data series, secondary axis.

 

This will add another axis on the right.

 

You can also add data labels and edit them, one by one, to the cummulative amounts.

I don't want to add it in the graph portion. I just want to add it at the end of the table below the graph. For example, I have:

                            OCT   NOV   DEC   JAN   FEB   MAR   APR   MAY   JUN   JULY   AUG   SEPT

Plan                      $16k    $69k  $93k etc....

Actuals                  $23.7k  $34k  $49k etc...

After the September data, I want to add a column that totals the year. I can add that, but then it messes up the graph. Obviously, for the actual data, I only have numbers through the end of Fiscal July. So, Aug and Sept have to be blank, and then I want to add the cumulative data after that.

I have a line graph (and a bar graph - two separate charts). They both have the fiscal year plan for a project, and the actuals. They are displayed on the graph in a non-cumulative format.

On the bottom of the chart, is the little table with the numbers.

My manager just asked if I could add the cumulative total for the year to the end of the table. Can I do that without adding it to the graph and screwing it up?

You could add it, then right click on the new series, and edit data series, secondary axis.

This will add another axis on the right.

You can also add data labels and edit them, one by one, to the cummulative amounts.