Hi,
Hoping someone can help me with this. I'm a longtime Excel user and very experienced and familiar with earlier versions of Excel pivot tables, pivot charts etc. However I have just started using Excel 2013 with PowerPivot and whilst it's a great leap forward, I am finding that one very simple thing appears to be impossible to do. That is, to get a pivot chart to correctly show the x axis values as percentages instead of decimals.
I have tried everything obvious: my source tables have the values correctly formatted as %, the data table in the data model is also formatted as %, and in the associated pivot table which the pivot chart is linked to the row labels are also formatted as %. I have also clicked on the X Axis on the chart itself and tried to change the format using the axis format dialogue, and that doesn't work either! That would have worked just fine in the old version of Excel.
What am I missing here? Or is this a known bug (I can scarcely believe that it would be)
Cheers and thanks in advance for any suggestions
David
Hoping someone can help me with this. I'm a longtime Excel user and very experienced and familiar with earlier versions of Excel pivot tables, pivot charts etc. However I have just started using Excel 2013 with PowerPivot and whilst it's a great leap forward, I am finding that one very simple thing appears to be impossible to do. That is, to get a pivot chart to correctly show the x axis values as percentages instead of decimals.
I have tried everything obvious: my source tables have the values correctly formatted as %, the data table in the data model is also formatted as %, and in the associated pivot table which the pivot chart is linked to the row labels are also formatted as %. I have also clicked on the X Axis on the chart itself and tried to change the format using the axis format dialogue, and that doesn't work either! That would have worked just fine in the old version of Excel.
What am I missing here? Or is this a known bug (I can scarcely believe that it would be)
Cheers and thanks in advance for any suggestions
David