Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Can you create 1 chart that will update based on filtered data?
I have budget data for 120 or so medical centers in rows. I filter this data
by center. Is there a way to create one chart that will present data for only the center currently selected in the filter or would I have to create 120 diff charts? Thank you, |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
Can you create 1 chart that will update based on filtered data?
Hi,
Create you chart on all the data. Assuming your total data does not exceed the charts limits. Make sure the 'plot visible cells only' option is on. Tools Options Chart. If the chart is located near the data to be filtered you will need to change the Move and size properties of the chart object. Double click the chart area and see options on the Properties tab. You should then be good to go and filter the data. Cheers Andy Diane wrote: I have budget data for 120 or so medical centers in rows. I filter this data by center. Is there a way to create one chart that will present data for only the center currently selected in the filter or would I have to create 120 diff charts? Thank you, -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info |
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
Can you create 1 chart that will update based on filtered data
Thank you!!! You're wonderful!
"Andy Pope" wrote: Hi, Create you chart on all the data. Assuming your total data does not exceed the charts limits. Make sure the 'plot visible cells only' option is on. Tools Options Chart. If the chart is located near the data to be filtered you will need to change the Move and size properties of the chart object. Double click the chart area and see options on the Properties tab. You should then be good to go and filter the data. Cheers Andy Diane wrote: I have budget data for 120 or so medical centers in rows. I filter this data by center. Is there a way to create one chart that will present data for only the center currently selected in the filter or would I have to create 120 diff charts? Thank you, -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info |
#4
Posted to microsoft.public.excel.charting
|
|||
|
|||
Can you create 1 chart that will update based on filtered data
:blush: thank you :)
Diane wrote: Thank you!!! You're wonderful! "Andy Pope" wrote: Hi, Create you chart on all the data. Assuming your total data does not exceed the charts limits. Make sure the 'plot visible cells only' option is on. Tools Options Chart. If the chart is located near the data to be filtered you will need to change the Move and size properties of the chart object. Double click the chart area and see options on the Properties tab. You should then be good to go and filter the data. Cheers Andy Diane wrote: I have budget data for 120 or so medical centers in rows. I filter this data by center. Is there a way to create one chart that will present data for only the center currently selected in the filter or would I have to create 120 diff charts? Thank you, -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I create a link between columns from a data chart? | Excel Discussion (Misc queries) | |||
Can I create an Excel chart from non-contiguous data cells? | Charts and Charting in Excel | |||
How do you update a pivot chart when the data is changed? | Excel Discussion (Misc queries) | |||
how to create a chart in excel with data from another workbook | Charts and Charting in Excel | |||
Excel 2002 chart does not update when worksheet data changes | Charts and Charting in Excel |