ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Creating a line chart with two X-axes!! (https://www.excelbanter.com/excel-discussion-misc-queries/33218-creating-line-chart-two-x-axes.html)

JaVaughn

Creating a line chart with two X-axes!!
 
Hello, thank you for replying.

Which chart type would allow for 2 X-axes. The only chart type that I know
that allows for 2 axes is "Line Chart with 2 Y-axes".

For the above-mentioned chart, the option to designate a primary and
secondary x-axis is displayed at the bottom of the "Source Data" window.
However, once the chart is created, only one x-axis scale is shown. I was
thinking that one x-axis scale would be along the bottom of the chart, and
the secondary x-axis scale would run along the top of the chart. But only
one x-axis appeared.

Please Help. Thanks


bj

Have a chart with the second axis selected.\
<chart<Chart Options<Axis select secondary x axis

"JaVaughn" wrote:

Hello, thank you for replying.

Which chart type would allow for 2 X-axes. The only chart type that I know
that allows for 2 axes is "Line Chart with 2 Y-axes".

For the above-mentioned chart, the option to designate a primary and
secondary x-axis is displayed at the bottom of the "Source Data" window.
However, once the chart is created, only one x-axis scale is shown. I was
thinking that one x-axis scale would be along the bottom of the chart, and
the secondary x-axis scale would run along the top of the chart. But only
one x-axis appeared.

Please Help. Thanks



All times are GMT +1. The time now is 05:36 AM.

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