X AXIS Graph

  • Thread starter Thread starter Kelston
  • Start date Start date
K

Kelston

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

Let me explain. If you have two columns of data. One covers 1000 row
and another 1300 rows but you want both data sets to go the full lengt
of the X axis. Can this be done
 
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/
_______
 
You must log in or register to reply here.

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

create chart with column axis 10
Exel - add vertical line to two axis graph 0
special graph format 3
Extract Cell Contents to String 3
dynamically increase x axis 5
Graphing by seconds 2
Best method / software for graphical output from dynamic excel data 0
Generating Graphs (XY scatter Plot) 1

Back
Top