Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
X AXIS Graph
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 -- Message posted from http://www.ExcelForum.com |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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/ |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Want graph with 2 axis, but bars overlap when second axis added | Charts and Charting in Excel | |||
X axis on Graph?? | Charts and Charting in Excel | |||
how can i plot two different y-axis graph with same x-axis | Excel Discussion (Misc queries) | |||
can I make the vertical axis the category axis in Excel line graph | Charts and Charting in Excel | |||
2 axis bar graph | Excel Discussion (Misc queries) |