I have a Pivot Table that is generated from an OLAP cube. I created a
Pivot Chart, but this is not as flexible as I would like. I want to
add a couple of extra trendlines so that I can see if my data series
falls within an acceptable range.

To accomplish what I want I create a standard chart, use VBA to get the
series & axes from the Pivot Chart, and then add the series and axes to
the standard chart. All of that is working well. Except for one
thing. I can't get the category axis to format the same way as it is
formatted on the Pivot Chart.

For example, if I use a date as my row values on the Pivot Table and
select the lowest drill-through value(which is month in my case), the
Pivot Chart will show the Year, Quarter and Month as category names.
My formatting problem has to do with the orientation and alignment of
each category name level. The pivot table seems to able to have a
different orientation or alignment for the Year, Quarter or month,
which I have not been able to reproduce on the standard chart.

Any idea on how I can exactly reproduce the formatting of the Pivot
Chart category asix? Or is there another way I could do what I
attempting to do with the trendlines? Again though, other than the
formatting of the category axis, everything is working well.