Prevent overlapping Numbers line graph

Question

Level 1

8 points

Prevent overlapping Numbers line graph

I'm working on Numbers 11.1. I am creating a graph line with two lines (2 groups) with 12 data for each line (24 data total). Each data has error bars. When I create my graph, I would like to shift (left or right) one of the lines (data symbol and error bars) so that there is no overlapping of data symbol nor error bars.

Is it possible ?

MacBook Air 13″, macOS 11.5

Posted on Aug 24, 2021 12:07 PM

Reply

Answer 1

Best reply

Badunit

Level 7

26,662 points

Aug 24, 2021 12:55 PM in response to emile241

You mean like this (not all of my table is in the screenshot)?

I did that by making two charts and putting one on top of the other.

Make a chart of the first series
Copy/Paste it then Edit Data References and change the data of the copy to the second series
Place it on top of the other, shifted to the right.
Remove all the duplicated stuff (grid lines, axis lines, category labels, etc). If you shift it over by much you might need to keep the X axis and horizontal gridlines so they extend far enough.
Change the series color to something else.

Reply

Answer 2

emile241 Author

Level 1

8 points

Aug 25, 2021 6:09 AM in response to Badunit

Thanks, I'll do it like that

Reply

Prevent overlapping Numbers line graph

Similar questions