I'm building a chart from 3 series of data. Mac Excel 16.16.12
The issues:
It's as if adding series 2 somehow overwrites series 1.
The 3 series come from a total of 16 non-contiguous ranges. Series 1 has 6 ranges, series 2 has 4 ranges, and series 3 has 6 ranges.
I'm clearly missing something basic.
Help required.
Thank you.
The issues:
- Adding data series 1 is all ok and called "Series 1 "Point A"" on the chart. All category names on X-axis are correct.
- Adding series 2 is ok and called "Series 2 "Point B"" on the chart; however, "Series 1 "Point A"" then changes title to "Series 1 "Point B"".
- Category names on the X-axis do not show both series 1 and series 2; instead, when adding series 2, X-axis category names for series 1 are replaced by X-axis category names for series 2.
It's as if adding series 2 somehow overwrites series 1.
The 3 series come from a total of 16 non-contiguous ranges. Series 1 has 6 ranges, series 2 has 4 ranges, and series 3 has 6 ranges.
I'm clearly missing something basic.
Help required.
Thank you.