Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Chart templates treates value axis as a category axis
I saved a Chart Template [Line Plot Type] that uses a horizontal value axis,
but when I try to use it in a new workbook, the data is plotted with a horizontal category axis? |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
Chart templates treates value axis as a category axis
In a line chart, the horizontal (X) axis IS a category axis. Only an XY
chart has a value horizontal axis. - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services, Inc. http://PeltierTech.com/WordPress/ _______ "FHW at EAD" <FHW at wrote in message ... I saved a Chart Template [Line Plot Type] that uses a horizontal value axis, but when I try to use it in a new workbook, the data is plotted with a horizontal category axis? |
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
Chart templates treates value axis as a category axis
Jon,
I'm sorry I incorrectly stated the question: It was an XY chart that I had saved as a chart template. When I tried to apply the chart template it changed the X axis to a category axis [using the ordered sequence rather than the actual X-values. FHW "Jon Peltier" wrote: In a line chart, the horizontal (X) axis IS a category axis. Only an XY chart has a value horizontal axis. - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services, Inc. http://PeltierTech.com/WordPress/ _______ "FHW at EAD" <FHW at wrote in message ... I saved a Chart Template [Line Plot Type] that uses a horizontal value axis, but when I try to use it in a new workbook, the data is plotted with a horizontal category axis? |
#4
Posted to microsoft.public.excel.charting
|
|||
|
|||
Chart templates treates value axis as a category axis
Aha. Probably the X axis data were not recognized as numeric. In this case,
Excel just uses 1, 2, 3, etc. This happens often with imported data, and it only takes a single non-numeric value to spoil a whole set of X values. - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services, Inc. http://PeltierTech.com/WordPress/ _______ "FHW at EAD" wrote in message ... Jon, I'm sorry I incorrectly stated the question: It was an XY chart that I had saved as a chart template. When I tried to apply the chart template it changed the X axis to a category axis [using the ordered sequence rather than the actual X-values. FHW "Jon Peltier" wrote: In a line chart, the horizontal (X) axis IS a category axis. Only an XY chart has a value horizontal axis. - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services, Inc. http://PeltierTech.com/WordPress/ _______ "FHW at EAD" <FHW at wrote in message ... I saved a Chart Template [Line Plot Type] that uses a horizontal value axis, but when I try to use it in a new workbook, the data is plotted with a horizontal category axis? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
can I make the vertical axis the category axis in Excel line graph | Charts and Charting in Excel | |||
stock chart category axis | Charts and Charting in Excel | |||
Category axis in bubble chart | Charts and Charting in Excel | |||
Adding data on Axis Major Gridlines next to Category Axis Collums | New Users to Excel | |||
How do I make the Y axis in an excel chart the category axis? | Charts and Charting in Excel |