Hi.
I have a simple, two lines chart.
My X-Axis range has dates, linked to source.
As soon as I define one of the y-axis lines to be on a secondary axis - the dates formatting of the x-Axis are removed and all labels are shows as a sequence of numbers: 1 2 3 4 5 6...
Setting it back on the primary axis - shows the X-axis labels correctly.
<tbody>
</tbody>
I tries forcing x-Axis Type to be Date Axis - no effect.
Any ideas on how to retain the X-axis formatting to be linked to source and show the dates, while two Y-axis in effect?
I have a simple, two lines chart.
My X-Axis range has dates, linked to source.
As soon as I define one of the y-axis lines to be on a secondary axis - the dates formatting of the x-Axis are removed and all labels are shows as a sequence of numbers: 1 2 3 4 5 6...
Setting it back on the primary axis - shows the X-axis labels correctly.
X-Axis | Y-Values1 | Y-Values2 |
Jan-17 | 45 | 4658 |
Feb-17 | 33 | 6845 |
Mar-17 | 40 | 7651 |
Apr-17 | 29 | 3486 |
<tbody>
</tbody>
I tries forcing x-Axis Type to be Date Axis - no effect.
Any ideas on how to retain the X-axis formatting to be linked to source and show the dates, while two Y-axis in effect?