graph based on the city i select in a particular cell

N

Nikhil

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
 
A

Andy Pope

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Create a chart from a table in word thats dynamic 0
Add footer based on header building block 0
Index/Match Functions to Return Concatenated Response 4
Custom Number sequences 0
Creating a Chart on form from selected data in query. 0
Link a text box based on drop down box with four options MS Word 365 0
Plotting data points on 2 axis 4
Sumproduct Column B based on Column A 4

Top