C clumpa Member Dec 16, 2011 #1 New to charting. Data builds up over 15 weeks. 16 Names in column A1 thro A16 and data in columns B thro P. Trying to have a line chart for each of the 16 names. Going round in circles!! Any help would be appreciated Using Excel for Mac 2011
New to charting. Data builds up over 15 weeks. 16 Names in column A1 thro A16 and data in columns B thro P. Trying to have a line chart for each of the 16 names. Going round in circles!! Any help would be appreciated Using Excel for Mac 2011
Hui Excel Ninja Staff member Dec 17, 2011 #2 Have a look at: http://chandoo.org/wp/2009/10/15/dynamic-chart-data-series/
C clumpa Member Dec 17, 2011 #3 That's where I started! It does not explain where/how to use years-data or how to edit series, which I cannot find in Excel for Mac 2011.
That's where I started! It does not explain where/how to use years-data or how to edit series, which I cannot find in Excel for Mac 2011.
