P
Peter Müller
I have an "XY (Scatter)" chart ( Scatter with data points connected by
smoothed lines). I want to use to display calendar weeks as labels for
the X axis. The problem there is that at the end of a year the number
jumps from 53 to 1. I read that one can do the job be adding a second X
axis but I have no further clue. I tried to add a second X axis but I
failed.
When I choose a Line chart (line with markers displayed at each data
value) and apply the following lines
ActiveChart.SeriesCollection(1).XValues = "=Sheet1!R1C1:R39C1"
ActiveChart.SeriesCollection(2).XValues = "=Sheet1!R1C1:R39C1"
ActiveChart.SeriesCollection(3).XValues = "=Sheet1!R1C1:R39C1"
ActiveChart.SeriesCollection(4).XValues = "=Sheet1!R1C1:R39C1"
I can provide an X axis showing the calendar weeks but I can specify
precise X values for my data points. Due to the fact one can chose the
chart type and XValues to any Series object I assume that there is way
to create an X axis having the desired values.
Who can I provide such X axis?
smoothed lines). I want to use to display calendar weeks as labels for
the X axis. The problem there is that at the end of a year the number
jumps from 53 to 1. I read that one can do the job be adding a second X
axis but I have no further clue. I tried to add a second X axis but I
failed.
When I choose a Line chart (line with markers displayed at each data
value) and apply the following lines
ActiveChart.SeriesCollection(1).XValues = "=Sheet1!R1C1:R39C1"
ActiveChart.SeriesCollection(2).XValues = "=Sheet1!R1C1:R39C1"
ActiveChart.SeriesCollection(3).XValues = "=Sheet1!R1C1:R39C1"
ActiveChart.SeriesCollection(4).XValues = "=Sheet1!R1C1:R39C1"
I can provide an X axis showing the calendar weeks but I can specify
precise X values for my data points. Due to the fact one can chose the
chart type and XValues to any Series object I assume that there is way
to create an X axis having the desired values.
Who can I provide such X axis?