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 |
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