Charts

  • Thread starter Thread starter Carol Matteson
  • Start date Start date
C

Carol Matteson

Does anyone know how (using a Stacked Column chart type)
to show a total in the data table but not in the chart? I
input my figures in the datasheet; I have two columns and
then I want a total, but as I said, I only want the total
to show in the data table (when I turn it on under Chart
Options), I don't want it to show in the stacked chart.
..
 
If you are using MS Graph, I don't believe it's possible, though I am
far from an expert in what some call MS Grump.

If you are using XL, don't use the chart's data table capability.
Instead, create the chart as an embedded object in a worksheet and copy
the data set into the cells just below the chart. Now, format the
chart and the worksheet to achieve the aesthetically desired effect.

For a just completed tutorial see the Excel | Tutorials | Custom Chart
Table page of my web site.

--
Regards,

Tushar Mehta, MS MVP -- Excel
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions
 
Thanks for your help. I checked out your web site. It
too was a lot of help. I really liked your slide
background, the light reflecting off the water. Nice
job.
 
[CRITICAL UPDATE - Anyone using Office 2003 should install the critical
update as soon as possible. From PowerPoint, choose "Help -> Check for
Updates".]

Hello,

Microsoft Graph doesn't provide the functionality that you are looking for.

If you (or anyone else reading this message) think that it's important that
Microsoft Graph provide this kind of functionality, don't forget to send
your feedback (in YOUR OWN WORDS, please) to Microsoft at:

http://register.microsoft.com/mswish/suggestion.asp

As with all product suggestions, it's important that you not just state
your wish but also WHY it is important to you that your product suggestion
be implemented by Microsoft. Microsoft receives thousands of product
suggestions every day and we read each one but, in any given product
development cycle, there are only sufficient resources to address the ones
that are most important to our customers so take the extra time to state
your case as clearly and completely as possible.

IMPORTANT: Each submission should be a single suggestion (not a list of
suggestions).

John Langhans
Microsoft Corporation
Supportability Program Manager
Microsoft Office PowerPoint for Windows
Microsoft Office Picture Manager for Windows

For FAQ's, highlights and top issues, visit the Microsoft PowerPoint
support center at: http://support.microsoft.com/default.aspx?pr=ppt
Search the Microsoft Knowledge Base at:
http://support.microsoft.com/default.aspx?pr=kbhowto

This posting is provided "AS IS" with no warranties, and confers no rights.
Use of any included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm
 
Back
Top