Excel 2007 : Graphing

[k24fan]

I am trying to put a line graph together. The problem is the graph is congested if all data is graphed. I want to give the user of the graph the ability to pick the data they want to view. I want to show the average gallons of fuel for all regions/offices and the gallons for an office from a drop down box in a line graph format. Please see attached. Any help is greatly appreciated.

Thanks!

[MarvinP]

Hi k24fan,

You need to make a table of your data and do a pivot chart on it. Then use the Region and Office as filters.

See the attached where Region and Office dropdowns are on chart. Easy Peasy!