Hi,
i would like to my chart part of my pivot chart to show the data row names to be more descriptive than the abbreviated data row names in the source.
attached is my data, in sheet 1, the data is in green with the corresponding pivot table.
for example on my data row of LL this stands for LEVEL LEVEL which is what i would like , ideally, on my chart.
i cant really change the source data to LEVEL LEVEL as i would receive it in abbreviated form in future.
please do reply if im not making sense, but basically on the chart, the name labels of LL,SW, etc above the 0, i would like to change their name
i have searched elsewhere , you tube , etc, but am getting just how to change headings, legend, name etc.
so much thanks for any help whom may know an answer to this
steve
Bookmarks