| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Can you show data in a data table but not plot it on the chart?
I need to be able to include a total column in a data table on the stacked
chart I'm doing but not plot it on the chart itself. Is this possible and how? |
|
#2
|
|||
|
|||
|
Armadillo,
Unfortunately you can't add totals to a chart-generated data table. However, with a little formatting work you can create a data table with worksheets cells. Please see this site for an example: http://pubs.logicalexpressions.com/p...cle.asp?ID=509 ---------------------------- Regards, John Mansfield http://www.pdbook.com "Armadillo" wrote: I need to be able to include a total column in a data table on the stacked chart I'm doing but not plot it on the chart itself. Is this possible and how? |
|
#3
|
|||
|
|||
|
In general John's suggestion is best. However, if it's not a complicated
table, you could add the Total series to the chart, then format it so it doesn't show (no line, no markers, no fill, nothing). - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services Tutorials and Custom Solutions http://PeltierTech.com/ _______ Armadillo wrote: I need to be able to include a total column in a data table on the stacked chart I'm doing but not plot it on the chart itself. Is this possible and how? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Problem making versions of a table by changing sourse data in another workbook | Excel Discussion (Misc queries) | |||
| 1-variable Data Table dependent on MS Query fails to update correctly | Excel Discussion (Misc queries) | |||
| missing data from table | Excel Discussion (Misc queries) | |||
| missing data from table | Excel Discussion (Misc queries) | |||
| multiple or changing colours in a data table on an excel chart fo. | Charts and Charting in Excel | |||
Linear Mode
