Can anyone help or explain if this is possible please???
I have a chart which is generated by a pivot, in the chart are the fields which you can drop down and select what you want to view.
For example, Jan, Feb, Mar, Apr, May, etc.
But..... however clever this is and preferable for me, when i print the sheet the chart just shows a field button with period in it. Is there a way i can get the chart to display the periods chosen, rather than having them in the axis of the chart?
Bookmarks