Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
control buttons for chart
I'm using Excel 2007;
I have a table linked to my chart. I'm filtering the table on two different columns (produce grade and customer) to produce the charts that I want (CM%). It works great. I need to control the table (chart) filters from the face of the Chart and keep the table sheet hidden. Thus, I'd like to add two buttons to the chart face to control the filtering. How do I reference a control to a table filter? And also I'll need to make it clear the filter (since I'm using two independent filters) before each attempted change. Ideas anyone? |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
control buttons for chart
Never Mind, I figured it out. It took a couple hours, but i got it.
"Kyle Chastain" wrote: I'm using Excel 2007; I have a table linked to my chart. I'm filtering the table on two different columns (produce grade and customer) to produce the charts that I want (CM%). It works great. I need to control the table (chart) filters from the face of the Chart and keep the table sheet hidden. Thus, I'd like to add two buttons to the chart face to control the filtering. How do I reference a control to a table filter? And also I'll need to make it clear the filter (since I'm using two independent filters) before each attempted change. Ideas anyone? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Control Buttons frozen | Excel Discussion (Misc queries) | |||
Worksheets and Control Option Buttons | Excel Worksheet Functions | |||
Control Pivot Table By Command Buttons | Excel Discussion (Misc queries) | |||
Keeping Control Buttons Still | Excel Worksheet Functions | |||
No Buttons to Control Subtotal Levels!?!? | Excel Discussion (Misc queries) |