Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Total label for an excel bar graph 1
- Thread starter BPMan
- Start date
-
1
- #2
BPMan,
Sum your data series on the spreadsheet itself. Then don't show the values thru the chart options. Draw a new text box from the drawing toolbar atop the series. While it is still selected, use the formula bar and place a formula linking to the cell with the sum in it (i.e. =G5) and hit enter. The new total will be in the text box and can be moved adjacent or on top of the bar/column as desired.
Hope this helps.
Sum your data series on the spreadsheet itself. Then don't show the values thru the chart options. Draw a new text box from the drawing toolbar atop the series. While it is still selected, use the formula bar and place a formula linking to the cell with the sum in it (i.e. =G5) and hit enter. The new total will be in the text box and can be moved adjacent or on top of the bar/column as desired.
Hope this helps.
- Status
Similar threads
- Question
- Locked
- Question