Show AutoFilter selection in Graph Label

JPM

Active Member
Joined
Aug 1, 2002
Messages
407
I have a large table with sales data from different States in the U.S. In order to make the data meaningful to me I use AutoFilter to look at one State at a time. I also have a graph that is drawing its data from this table.

Is there a way to show in the Graph which state I have selected in AutoFilter?

Thanks in advance.
JPM
 

Excel Facts

Test for Multiple Conditions in IF?
Use AND(test, test, test, test) or OR(test, test, test, ...) as the logical_test argument of IF.

Oaktree

MrExcel MVP
Joined
Jun 20, 2002
Messages
8,053
Office Version
  1. 365
Have you considered creating a pivot chart?
 

JPM

Active Member
Joined
Aug 1, 2002
Messages
407
I tried that but that's not really working because I don't want to sum or count etc. the data for a state, all I want is to show me the data for the selected state --filter it. I guess I should have mentioned that I am using a Scatter chart, which does not work with pivot data.

Thanks though for the suggestion.
JPM
 

Jon Peltier

MrExcel MVP
Joined
May 14, 2003
Messages
5,156
Office Version
  1. 365
Platform
  1. Windows
  2. MacOS
You can make a regular chart from pivot data, enabling your XY chart. Select a blank cell located away from the pivot table, and start the chart wizard. In step 1, select the XY chart type you want. In step 2, click on the Series tab, and enter each series and its parameters here. When you change the pivot table, the chart keeps looking at the same cells, so it updates just fine.

Here's a hint: put the state field into the page area, and use the cell with the state's name as the name of the series.
 
Master Excel Bundle

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

Forum statistics

Threads
1,164,006
Messages
5,834,835
Members
430,324
Latest member
bosphoruskid

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top