graph chart, dialog

hostelowner

Board Regular
Joined
Apr 19, 2005
Messages
105
I have created a simple lin graph for 22 weeks of net sale per store location. y+ total $, and X = each week. The graph certainly looks great unfortunetly it looks a little crowded.

So i figured i could select each individual store to show only its sales by inserting a tab dialog, and create a drop down box giving me the option to either select all stores or indiviual stores. i managed to populate each drop down box. I even went to the length of creating another drop down to with select graph by district, outlet stores, and what not. but i have only reached the point where i have a tab for the graph showing all plotted data, a tab withthe actual data, and a dialog1 tab that again looks like it could work but doesn't

How can i make my graph interactive?
- select individual stores to show on graph
 

Some videos you may like

Excel Facts

Will the fill handle fill 1, 2, 3?
Yes! Type 1 in a cell. Hold down Ctrl while you drag the fill handle.

tusharm

MrExcel MVP
Joined
May 28, 2002
Messages
11,028
Use a PivotTable with an associated PivotChart. XL automatically adds interactivity to the PC.
 

hostelowner

Board Regular
Joined
Apr 19, 2005
Messages
105
pivoting the table

hi thanks

so, if i make the source file, (the chart containing all the data for the sheet showing the graph), into a pivot table, it will automatically show on the graph?
thanks
 

Watch MrExcel Video

Forum statistics

Threads
1,118,530
Messages
5,572,695
Members
412,481
Latest member
nhantam
Top