Row axis formating in Pivot Command

[Jean-Yves Le StangParticipant]

Hello,

The graph attached is generated with a “Pivot” command. I would like the Y axis (Rows) formatted differently (ICU format), but could not find any direct possibility in the (Pivot) command, neither in the axis formatting options. Am I right ?

I currently have a work-around by extracting data from the “Pivot”, formatting the Date and pulling everything in a “Bars” command and it is fine but a bit tedious.

Unless I missed something, I would suggest to allow formatting rows in the Pivot command, for graph as well as the Pivot table.

[dgteamModerator]

You can create a list of the dates in the format you want them in the data table. Then, use the Axis settings to use them as the label. Here is how you can set this up dynamically using just the Pivot command:

1. Click the gear menu icon in the top right corner of the Pivot command.
2. Select Extract as Column > Row Values. This creates a new column with the dates listed.
3. Change the Display option for this new column to ICU Format.
4. In the entry box that appears, type in the desired ICU code. Here, we used ‘d – MMM,’ which gives the day followed by the month’s abbreviation.
5. Expand the Axis settings and change the Y tick marks option to ‘Categories’ and the Labels to select the ‘Row Values’ column.

This does require an extra step, but there is no need to use a different drawing command.

[Jean-Yves Le StangParticipant]

Much better than my former process and succesfully tested. Many thanks

[Author]

Posts