X-axis scale

  • Thread starter Thread starter Fred
  • Start date Start date
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?
 
Instead of a line chart, create an XY (scatter) chart, and use one of
the line subtypes.
 
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?
 
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
Formatting 'X' Axis -- 2 fundamental differences 7
Make Y-axis values correspond to x- axis value 1
How can I make a scatter plot graph with a category x-axis? 0
Chart with differing x axis 1
Pareto diagram with 2 X-axis 2
Dynamically Scale X Axis on Column Chart Based on Number of Catego 1

Back
Top