Sort Pivot Chart
In Excel 2000, is there a way to sort a pivot chart by the summed data?
Thanks. |
Sort Pivot Chart
Hi,
Do you mean that you want to X axis to be sorted in some sort of order? In general if you want to display data on a pivot chart as sorted you sort the pivot table. So to be of any real help we need more detail. What do you want to sort? Are they row fields, column fields, data fields? How do you want them to sort? How are the fields layed out on the pivot table? -- Thanks, Shane Devenshire "Alex" wrote: In Excel 2000, is there a way to sort a pivot chart by the summed data? Thanks. |
Sort Pivot Chart
I'd like to sort by the data fields Grand Totals. How do I sort my pivot
table in Excel 2000? Thanks. "ShaneDevenshire" wrote: Hi, Do you mean that you want to X axis to be sorted in some sort of order? In general if you want to display data on a pivot chart as sorted you sort the pivot table. So to be of any real help we need more detail. What do you want to sort? Are they row fields, column fields, data fields? How do you want them to sort? How are the fields layed out on the pivot table? -- Thanks, Shane Devenshire "Alex" wrote: In Excel 2000, is there a way to sort a pivot chart by the summed data? Thanks. |
Sort Pivot Chart
I was able to sort my pivot table so I'm good now. Thanks much.
"ShaneDevenshire" wrote: Hi, Do you mean that you want to X axis to be sorted in some sort of order? In general if you want to display data on a pivot chart as sorted you sort the pivot table. So to be of any real help we need more detail. What do you want to sort? Are they row fields, column fields, data fields? How do you want them to sort? How are the fields layed out on the pivot table? -- Thanks, Shane Devenshire "Alex" wrote: In Excel 2000, is there a way to sort a pivot chart by the summed data? Thanks. |
All times are GMT +1. The time now is 04:34 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com