Excel scales the chart incorrectly?
I have a chart where I first measured the time (for the first 10 minutes) in 10-second increments, and then in 30-second increments. Now I'm having trouble with Excel, which is based on the chart positions and not the times. Therefore, there's a change in the chart at 10 minutes, which doesn't make sense.
(2 rating, 2 votes, rated)You need to be a registered member to rate this.
Loading...
You probably want to have presented the changes in the times.
Other times – other graphics
or
My problem is that I measured the first 10min more accurately and wrote the results in 10 seconds. Then I wrote the results in 30 seconds. Excel however goes after the number of columns and not after time. Therefore, first 10 seconds of steps are displayed and then 30 seconds of steps. Could I change this somehow?
See 3. Graphic, You can both display and display this via chart elements and data caption.
You already have.
Drag the / Your graphics into the width
To display all data, you need to make the chart much reflected.
Thank you for your answer. However, it is about jumping the distances from 10 seconds to suddenly 30 seconds and whether I can change this.