Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Area Chart Question
Hello,
I am graphing an area chart off a table of numbers. Is there a way to show the summary totals in the data table that I am showing on the graph without having the totals appear on the area graph itself? John |
#2
|
|||
|
|||
John,
Unfortunately the data tables are not going to give you a lot of flexibility. Whatever is in the chart is going to show up on the data table. To get around this restriction, I would suggest creating a data table made of worksheet cells as opposed to using the standard data table. The link below describes the process: http://www.pdbook.com/index.php/exce...n_data_tables/ ---- Regards, John Mansfield http://www.pdbook.com "John M" wrote: Hello, I am graphing an area chart off a table of numbers. Is there a way to show the summary totals in the data table that I am showing on the graph without having the totals appear on the area graph itself? John |
#3
|
|||
|
|||
John -
You can format the totals series to be invisible: Double click on it, Patterns tab, None for Area and Border. The Y axis will behave nicer if you change the series to a line series first: Select the series, choose Chart Type from the Chart menu, and pick out a line chart style. Now format this to be invisible: Double click, Patterns tab, None for Marker and for Line. This said, you may not care for the chart with a data table, since it forces the ends of the area segments off the ends of the chart, leaving an unsightly gap at either side. John's suggested approach is a decent alternative, and Tushar Mehta has some additional suggestions for data tables on his web site, http://tushar-mehta.com. - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services Tutorials and Custom Solutions http://PeltierTech.com/ _______ John M wrote: Hello, I am graphing an area chart off a table of numbers. Is there a way to show the summary totals in the data table that I am showing on the graph without having the totals appear on the area graph itself? John |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
add line to a stacked area chart already created | Charts and Charting in Excel | |||
How do I shade the area between two lines on a chart? | Charts and Charting in Excel | |||
basic pie chart question | Charts and Charting in Excel | |||
Setting custom chart causes plot area to collapse | Charts and Charting in Excel | |||
Area Chart Formatting Question | Charts and Charting in Excel |