I have an auto calculator for waterfall charts in excel. I paste this data
into a PPT datasheet to create the chart. I manually key in the total figure
for the last column bar.
I want this to be automatic within excel by using existing calculator &
dynamic range names. I can do most of this except for the last column bar for
the total figure. This is a variable depending on how many subjects are in
the chart. The calculator does generate this figure as it is the last entry
plus a cumulative add-up. I cannot figure out how to include in the dynamic
name range since it is only one figure and needs to be plotted on the chart
as the last data piece to complete the chart.