Hi,
Please assist in the Time Scale at X axis as per the attached file.
I can get the time correctly set at bar chart but not the scatter chart.
Thanks in advance.
Hi,
Please assist in the Time Scale at X axis as per the attached file.
I can get the time correctly set at bar chart but not the scatter chart.
Thanks in advance.
Those are not real times but simply text.
In the column chart that is okay as the axis is categorical and showing text.
In a scatter chart the xvalues can not be used as they are text. Therefore the chart defaults to a numeric sequence of 1,2,3 etc.
You need to create actual times in those cells. Note that then the points will all appear in the same horizontal position as the time is the same
Thanks, Andy.
I managed to set it and plot the scatter chart.
Would need some advise how to read/interpret the x axis values.
In what way?
If you mean the scale min/max/major/minor values then they are times in numeric format, which is 1 day = 1, 12 hours = 0.5
Thanks, Andy.
Got it.
Capture.JPG
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks