Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Secondary Axis Values Disappear
Office 2003
When I elect to "show data table" my secondary axis values disapper. As soon as I uncheck "show data table" in chart options, the axis values reappears. Can't I have both (secondary axis values AND data table)? TIA, Karen |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
Secondary Axis Values Disappear
Hi Karen,
Excel's chart data tables have many limitations. It depends what type of chart you have. Some types won't let you have a data table at all, some only for data on one axis. Some, like a column chart, will let you have a data table even if you have both primarty and secondary axes. If you have a combination chart, well, forget it! They also have very limited formatting and editing options. The best way is to build your own data table in the cells below the chart, and make it appear as though the two are connected. Dave url:http://www.ureader.com/msg/10296168.aspx |
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
Secondary Axis Values Disappear
and make it appear as though the two are connected.
Or not. One can take OCD to the extreme when it's really unnecessary. If you need a data table, maybe you don't need the chart? - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "Dave Curtis" wrote in message .. . Hi Karen, Excel's chart data tables have many limitations. It depends what type of chart you have. Some types won't let you have a data table at all, some only for data on one axis. Some, like a column chart, will let you have a data table even if you have both primarty and secondary axes. If you have a combination chart, well, forget it! They also have very limited formatting and editing options. The best way is to build your own data table in the cells below the chart, and make it appear as though the two are connected. Dave url:http://www.ureader.com/msg/10296168.aspx |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
xy-scatter-labels disappear when x-axis is changed into time-axis (XL07) | Charts and Charting in Excel | |||
On a secondary Y-axis, scale values are repeated: 1, 1, 2, 2. | Charts and Charting in Excel | |||
How to place a secondary y axis bar in a bar chart next to two primary y axis bars? | Excel Discussion (Misc queries) | |||
Pivot Table, Line Chart with Secondary Y axis, Page Field selection destroys Y2 axis | Charts and Charting in Excel | |||
Secondary Axis Annual Units sold on 1 Y Axis - Dollar Volume on another | Charts and Charting in Excel |