Thread: X AXIS Graph
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Jon Peltier[_7_] Jon Peltier[_7_] is offline
external usenet poster
 
Posts: 115
Default X AXIS Graph

You realize the spacing per X Axis Category will be different? Good.
Then draw your chart with both series. Double click one of the series,
and on the Axis tab, choose Secondary, and press OK. Now right click on
the chart, select Chart Options, and on the Axes tab, check the
secondary X axis and uncheck the secondary Y axis.

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

Kelston < wrote:

Is there a way you can have two different sized columns of data on a
line graph without Excel keeping them both to a the same 'tick' by
Row.

Let me explain. If you have two columns of data. One covers 1000 rows
and another 1300 rows but you want both data sets to go the full length
of the X axis. Can this be done?


---
Message posted from http://www.ExcelForum.com/