Hi All, Im trying to do a line graph to compare data. The data involves only the first five months from last year and the first five months from this year. Also I have three sets of data to compare. 1st problem is when I graph, it seems to give me all of last years, even though there's no data for the last 7 months of last year; theres still a flat line. How do I get rid of it. When I try to plot just last years it doesn't go well when I try to add the months for this year. sample data
This nums are just made of to show you the format in cells I need the line graph to represent the multiple data on the same chart: jan08-may08 gross, jan09-may09 gross, jan08-may08 net jan09-may09 total, jan08-may08 total, jan09-may09 total,
Please help
Thanks
Bookmarks