Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
graph based on the city i select in a particular cell
I have cities and no. of stores in each city. For each store i have 2 data
points. Can I have a graph based on a city i select in a drop down cell.. e.g if i select a city A, the graph should display for stores located in City A, if i select City B, the stores of City B get displayed in the chart Plz help Nikhil |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
graph based on the city i select in a particular cell
Hi,
Depending on how you data and chart is setup you maybe able to use Autofilter. Select the chart and make sure the option to plot visible cells only is set. Tools Options Charts Plot visible cells only. Cheers Andy -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info "Nikhil" wrote in message ... I have cities and no. of stores in each city. For each store i have 2 data points. Can I have a graph based on a city i select in a drop down cell.. e.g if i select a city A, the graph should display for stores located in City A, if i select City B, the stores of City B get displayed in the chart Plz help Nikhil |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Select a cell based on an other cell's value | Excel Worksheet Functions | |||
Help tonight?!! select rows based on cell value in a column | Excel Worksheet Functions | |||
How do I Select Multiple Non Adjacent Rows based on a cell value? | Excel Worksheet Functions | |||
how can I select a range of cells based on a value of a cell? | Excel Discussion (Misc queries) | |||
Can I select a worksheet based upon a cell criteria?(for printing) | Excel Worksheet Functions |