Exclude Row Fields As Labels In Pivot Chart

[goss]

Hi all,

Using Excel 2016.

I have time bucket values in two different fields in the data source.
For example 12 - , 6 | 6 -, 10 | etc...
I added these fields to the Rows Filed of the Pivot Table (Tablular)

The chart looks good, but I would like to remove the day part labels from the Category axis. while retaining the chart as-is.
How can I accomplish this?

thx.

 

[goss]

I could not figure out how to create the Pivot Chart without the Row Fields as labels, so I created a normal table of values from the Pivot Table without the unwanted Row Fields and then created a chart from the normal table of values. I'll have to go back later to add some code to delete the table and update based on selected slicer values, but I am able to display the charts I was looking for the time being.

thx.