Excel Chart

[RonB]

When I add a data table to an existing chart the headers are reversed. For
instance the data for June 2008 shows up as the last date March 2006. The
chart it's self is correct. Is this a bug? I tried the same thing in Office
2003 and it worked correctly.

 

[dale]

2 problems--1st problem, I have 5 columns in my spreadsheet, but the longer I make my chart, the more "series" I have (currently 21, not 5). how do I limit the number of series in my chart.

2nd problem, How do I change my y axis legend from "series 1, series 2..." to reading data from my title row in my spreadsheet, (eg. "Highest, Lowest,...")