Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
How to sort x-axis in pivot chart
Hi,
I've a pivot chart, based on a pivot table. In the chart I display per x-label 3 variables, on top of each other. In the corresponding pivot table I have the x-lables as rows and 3 columns. Now I want to sort the x-labels on the sum of the 3 variables (or sorting the rows of the table). How can I do that? ( I'm able to sort on each variable distinctly, but that is not what I want. Further I can add a new variable to the table containing the sum of the 3 and sorting on that. But that gives a 4th variable in the chart. ) Can anyone help? Regards, Henk |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
chart from Pivot chart | Charts and Charting in Excel | |||
negative [h]:mm:ss does not show on the x axis of a chart | Charts and Charting in Excel | |||
tick mark labels | Charts and Charting in Excel | |||
pivot chart format | Charts and Charting in Excel | |||
Second X axis at top of chart? | Charts and Charting in Excel |