X-axis scale

F

Fred

When making a line chart my Excel 97 automatically makes
the x-axis a category axis. How can I make it a value axis?
 
D

Debra Dalgleish

Instead of a line chart, create an XY (scatter) chart, and use one of
the line subtypes.
 
R

Ruth

I am constructing a bar chart and would like to be able to
change my x-axis to a value axis.
Unfortunately for what I am doing I have to use a bar
chart but need times along the x-axis. Is there anyway to
do this?
 
J

Jon Peltier

Ruth -

The X axis of a bar chart (the vertical axis of a chart having
horizontally oriented rectangles) can only be category or date, not
value or time. If you mean the horizontal axis of a horizontally
oriented chart, that's the Y axis, and you can use times. Double click
the axis, on the number tab, pick the desired number format, and on the
scale tab, enter values as times in H:MM or H:MM:SS formats (you must
include hours).

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Horizontal axis to the bottom 1
Time(X) Axis Scale in 97 5
Make Y-axis values correspond to x- axis value 1
Formatting 'X' Axis -- 2 fundamental differences 7
Dynamically Scale X Axis on Column Chart Based on Number of Catego 1
extra info is showing up in my secondary x axis, I can't get rid o 1
X-axis in 2007 4
Primary X axis to Secondary X axis 1

Top