Dual x-axis

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have tried to use custom charts to create a bar or line chart with 2 x-axis
where the x-axis are different. I want to chart 26 bi-monthly pay periods
(cost) and also show monthly employee levels (to make it simple, numbers of
employees) on the same chart. Is it possible to have 2 x-axis, bi-monthly
and monthly (and y-axis, cost and employee count) on one chart?
 
When you make a chart and assign a series to the secondary axis, Excel
generally just gives you a secondary Y axis. To get the secondary X
axis, make sure a series is on the secondary axis, then go to Chart
Options on the Chart menu, Axes tab, and check and uncheck the various
axes you need.

Don't waste your time by the way with the custom built-in charts. Make
your own chart from scratch, and you'll have much better control over
it. Plot all the data as one chart type on the primary axis. Select each
series you want to switch. To switch axis, double click on the series,
and choose the axis you want on the Axis tab. To change the chart type
(in case you want to mix column and line, for instance), select the
series and use Chart Type on the Chart menu.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______
 
Thank you Jon. This answers my question. I hit the button to notify MS as
well. Good job. Glad you folks are there for us.
 
Back
Top