ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   How to make cumulative totals appear on a graph (https://www.excelbanter.com/excel-discussion-misc-queries/4030-how-make-cumulative-totals-appear-graph.html)

Arlen

How to make cumulative totals appear on a graph
 
We are trying to track daily production at a dentist's office. Is it
possible to make the data labels on the graph display both the daily and
cumulative total at every tick mark?

Thanks for your help.

Arlen

Jim Cone

Arlen,

If you have a list on a worksheet with the desired data shown in
each cell, then my Excel add-in "Chart Data Labels" can add
linked formatted data labels to the chart using the
data from each cell.
It will also position the labels where you want them.

You might also want to consider a stacked bar chart with
the daily and cumulative in each bar.

"Chart Data Labels" -free- upon direct request.
Remove xxx from my email address.

Regards,
Jim Cone
San Francisco, USA
XX



"Arlen" wrote in message
...
We are trying to track daily production at a dentist's office. Is it
possible to make the data labels on the graph display both the daily and
cumulative total at every tick mark?
Thanks for your help.
Arlen



All times are GMT +1. The time now is 06:14 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com