Chart templates treates value axis as a category axis

  • Thread starter Thread starter FHW at EAD
  • Start date Start date
F

FHW at EAD

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?
 
In a line chart, the horizontal (X) axis IS a category axis. Only an XY
chart has a value horizontal axis.

- Jon
 
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 said:
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 said:
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?
Click to expand...
Click to expand...
 
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 said:
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 said:
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 said:
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?
Click to expand...
Click to expand...
Click to expand...
 
Back
Top