Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
graph
the easiest would be to create a defined name (insert=Name=Define) which
uses the offset function to point to your ranges Name: rng2005 Refersto: =offset(UnitByRCC!$M$65,0,Sheet1!A1,12,1) then have the combobox results translated into 0, 1 or 2 in cell A1 of Sheet1 (as per the example - adjust to suit) Have the graph used the defined name as the data source. -- Regards, Tom Ogilvy "geebee" (noSPAMs) wrote in message ... hi, I would like to add a combobox with three possible selections: one, two, three. Also there is a graph in the sheet. The graph contains 2 lines, or "series". "2005" series and "2006" series. Depending on the value selected form the combobox, I want the graphs source to change. For example: If select "one" from combobox: 2005 series =UnitByRCC!$M$65:$M$76 2006 series =UnitByRCC!$M$77:$M$88 If select "two" from combobox: 2005 series =UnitByRCC!$N$65:$N$76 2006 series =UnitByRCC!$N$77:$N$88 If select "three" from combobox: 2005 series =UnitByRCC!$O$65:$O$76 2006 series =UnitByRCC!$O$77:$O$88 How can I do this? Thanks in advance, geebee |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Combining a 2-D column graph and a 2-D line graph on the same char | Charts and Charting in Excel | |||
How do I graph data daily as a line graph across a calendar format | Charts and Charting in Excel | |||
Cluster stacked graph AND line combo graph? | Charts and Charting in Excel | |||
Powerpoint Graph- Shading in between two linear graph lines | Charts and Charting in Excel | |||
Hyperlinkage of one graph with another graph or Drill down graph | Charts and Charting in Excel |