ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)
-   -   Column Graphs (https://www.excelbanter.com/charts-charting-excel/56641-column-graphs.html)

lkegley

Column Graphs
 
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


Jon Peltier

Column Graphs
 
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/ChartsH...ValueAxis.html
http://pubs.logicalexpressions.com/P...cle.asp?ID=190

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

"lkegley" wrote in message
...
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





All times are GMT +1. The time now is 09:17 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com