Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Double click on chart column to get another chart
Hi...I have a column chart...what i did like to do is if the user clicks on
the column, there will be another chart that will come up...if he clicks on the second column chart there would be a third chart that wil come up... Basically i have data at Regional level, zonal level and then at city level.... can you help? Nikhil |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
Double click on chart column to get another chart
One way of getting dynamic charts is with AutoFilter. Have all the data on
one worksheet with columns to represent Regional level, Zonal level and City level. All rows of data would be Regional, Zone name against the data for specific zones and City name against data for each city. Now depending on how your chart is set up, you can either select all of the data for the chart and then set filters for the Region, Zone or City. Alternatively you can use the SUBTOTAL function and set the chart on the subtotal line only and the subtotals are dynamic with the AutoFilter selections. Suggest that you look up subtotal function in help for the parameters representing the various mathematical calculations. One other tip is to leave six or so lines above the column headers and then Freeze the panes so that the column headers and rows above are always displayed irrespective of how far you scroll down the screen. You can then place the subtotals in this area at the top of the screen and they are always visible and never have to be moved as you add rows of data. (You need to use all of the rows to the bottom of the worksheet in the subtotal functions.) I am sure if you google excel charts and autofilter you will find some examples. -- Regards, OssieMac |
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
Double click on chart column to get another chart
Hi,
You could also create a pivot table from your data and then plot that. You can then group by Region, Zonal Level, and City and expand or collapse at any level. When you do that to the pivot table it gets done automatically on the chart. -- If this helps, please click the Yes button. Cheers, Shane Devenshire "Nikhil" wrote: Hi...I have a column chart...what i did like to do is if the user clicks on the column, there will be another chart that will come up...if he clicks on the second column chart there would be a third chart that wil come up... Basically i have data at Regional level, zonal level and then at city level.... can you help? Nikhil |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
double clicking and draging a column in a chart to chg data | Charts and Charting in Excel | |||
Double-stacked Bar Chart WITH a Secondary Y Axis Line chart? | Charts and Charting in Excel | |||
Double GET-Request if click on a hyperlink in a column | Excel Discussion (Misc queries) | |||
double column chart | Charts and Charting in Excel | |||
Zip + 4 format column then must double click to change - why? | Excel Discussion (Misc queries) |