| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Auto Pareto Chart
I have a typical Histogram showing the number of incidents that occured by type. I am trying to create an automatic action for the user that re-sorts the data in the chart and reflects in the chart in a decending method. I can do this using a pivot table with no problem but the pivot table requires the user to perform a refresh....I do not want the to have to perform any operations to update the chart if possible. I tried some VBA code to fresh the Pivot table based on the internal clock but this ended up causing some other problems. I am open for any suggestions and can email original data if for your review. Thanks and HAPPY Holidays -- Robert_L. ------------------------------------------------------------------------ Robert_L.'s Profile: http://www.excelforum.com/member.php...o&userid=21791 View this thread: http://www.excelforum.com/showthread...hreadid=495941 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Activating a Chart object | Charts and Charting in Excel | |||
| Chart Axis Scale Auto Values | Charts and Charting in Excel | |||
| Urgent Chart Questions | Excel Discussion (Misc queries) | |||
| Urgent Chart Assistance Requested | Excel Discussion (Misc queries) | |||
| Auto Expanding Pie Chart | Charts and Charting in Excel | |||
Threaded Mode
