Chart Help

Ok, I'm a newbie. I have a simple chart of percentages, dates and locations


Date Date Date

Location 3 3 3
Location 2 2 2
etc

When I graph the first location all is fine. When I increase the data range to include the second location it adds it to the first location and the second line on the graph is the total. If I add more locations it just keeps increasing the values. I know it is probably just a simple answer but any help would be appreciated.

Verdero Green

When you add the second set of data add it as Series 2 (find series 1 and Add another series in Source Data)

--

Originally Posted by Verdero Green

Ok, I'm a newbie. I have a simple chart of percentages, dates and locations


Date Date Date

Location 3 3 3
Location 2 2 2
etc

When I graph the first location all is fine. When I increase the data range to include the second location it adds it to the first location and the second line on the graph is the total. If I add more locations it just keeps increasing the values. I know it is probably just a simple answer but any help would be appreciated.

Verdero Green