Hello,
I have two sets of data setup in the following way on an excel spreadsheet:
I want to list both sets of data in one scatter chart with different colours for each area, however when I try this, excel creates two legends on the graph and relists each of the 3 areas. How can I stop it from doing this? Do I need to layout my data in a different way to achieve this?
Bookmarks