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? |
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? |
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? |
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? |
All times are GMT +1. The time now is 03:44 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com