Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Uniquely Identify Data for Charting with a List Box
Gang,
The Internet is a great thing. I found a charting example that does nearly every thing I want to do. Amazingly enough, I was able to figure out how the thing works! The chart is fairly simple. It is a X*Y line chart with 2 series. I found the chart he http://peltiertech.com/Excel/ChartsH...iffSheets.html - The chart is called "ChartAgainstStandard.zip." One of the 2 series plotted is a "standard" and the other changes based on the selection made in the drop down list. Amazingly enough, I was able to follow the thing completely and I would like to model one after that. Mine, however, will be a little different (aren't they always). Whom ever created the chart, had each of the 4 series on separate sheets (names of sheets corresponded to the names in the drop down list). That unique name was used in the cell reference to point to the correct sheet for charting. This was the formula used :INDIRECT("'"&INDEX($O$3:$O$6,$O$1)&"'!"&ADDRESS(R OW(B1),COLUMN(B1))). Unfortunately, my data is not set up in separate sheets and I'm at a loss as to how to uniquely identify the correct data for plotting. My only thought was to use named ranges. Here's a chunk of data. All the data is in a single worksheet, in fact, it is inside a pivot table. Mind you, it doesn't have to be. I can pull it from two worksheets if need be. I put it all into a single table because I thought it would make it easier to plot (certainly to look at). Anyhow, the data that I want to plot came from two pivot tables. CountyName ModelSource 1981 1982 1983 ... 2006 Adams ASM 220 300 400 5,500 Adams DLW 140 200 275 4,400 Allen ASM 220 300 400 5,500 Allen DLW 140 200 275 4,400 Ashalnd ASM 220 300 400 5,500 Ashland DLW 140 200 275 4,400 .. .. .. Wyandot ASM 220 300 400 5,500 Wyandot DLW 140 200 275 4,400 As you might imagine, year will be the x-axis and the population estimates will be my y-axis. There will be 2 series - ASM and DLW, population estimates derived from different models. If anyone can help me with some ideas or examples on how I might "point" to the correct data for plotting, I would really appreciate it. Regards, Mike |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
using list box to edit or select data | Excel Discussion (Misc queries) | |||
update data validation list with new entries?? | Excel Discussion (Misc queries) | |||
Help PLEASE! Not sure what answer is: Match? Index? Other? | Excel Worksheet Functions | |||
named range, data validation: list non-selected items, and new added items | Excel Discussion (Misc queries) | |||
Pull Current Month's Data Out of List - Repost | Excel Discussion (Misc queries) |