Right click in the chart area and select 'source data' then 'series'.
Under the series box click 'add' to add the individual stores. If the
data ranges for the individual stores are wildly different from the
total you can use secondary axes for both X and Y to make the chart
easier to read. I have an example chart - if you send me an e-mail
address to reply to I'll forward a copy.
I am trying to plot three non-adjacent data sets (x-y) such as
columns b,c and g,h and n,o with the b,c, and n being
the x values. I'd like to do it from a macro, but even
manually would be good. Thanks for any help.