Column Graphs

L

lkegley

I am having trouble with the scaling of my X axis (catagory axis) for a
column chart that I have created. It is a series of numbers from 0 to 55. I
need the graph to have a linear scale at the bottom and the columns to be
distributed accordingly. Any suggestions? Thanks
 
J

Jon Peltier

What data are you using for your X values?

A column chart does not have a numerical axis. The axis is comprised of a
set of labels, or placeholders. Do you need columns, or would another chart
type do?

Information on chart types and axis types:

http://peltiertech.com/Excel/ChartsHowTo/CatVsValueAxis.html
http://pubs.logicalexpressions.com/Pub0009/LPMArticle.asp?ID=190

- 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

Make Y-axis values correspond to x- axis value 1
Combining a 2-D column graph and a 2-D line graph on the same char 3
Use text descriptors as Y axis units 1
Plotting Graph with dynamic table 3
Dynamic series in rows 1
how to produce a lin-log graph instead of log-lin graph? 1
Problem with Excel 2007 clustered column chart on log scale 1
Custom Format numbers for learning chart 0

Top