I have a spreadsheet that I am using to design dashboards. The graph will pull its data from the two columns that are blank on the attached spreadsheet. What I am trying to do is have those two columns populate with the data from the respective ranges (i have not named them in excel, but rather gave them a higlighted heading). Cell A1 will either be 1, 2, 3, 4, 5. If A1 =1 then I need the two empty columns to be populated with the data in the columns for that range and so-on. Will probably make more sense with the spreadsheet.
Bookmarks