ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)
-   -   "X" Axis with different scale (https://www.excelbanter.com/charts-charting-excel/66011-x-axis-different-scale.html)

maperalia

"X" Axis with different scale
 
I have created a secondary "X" axis under this description:
1.- On the bottom is in days.
2.- On the top is in months

However, when I plot the graph the chart is reading the secondary axis
values only.
When I setup the graph to read the primary axis value the graph does read
the secondary axis value.

Question:
It that possible to setup the chart to make it match the values in both
axis. For example, when the value in the bottom is "30" I want to see the
equivalent of "1" on the top, when the value on the bottom is "60" I want to
see the equivalent of "2" on the top and so on.

Thanks in Advance.
Maperalia



All times are GMT +1. The time now is 05:52 PM.

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