Hello,

I am trying to create a stacked area Pivot Chart from a Pivot Table. I
have negative values but am having trouble getting them to be
displayed properly in the pivot chart. Currently, the negative values
are displayed at the top and are "eating into" the positive series. I
need the negative values to be displayed below the x-axis. Any help
would be greatly appreciated.

Aleksandr,
This may be silly to ask, but...
Did you try and adjust the y-axis scale from 0 to some number to a negative
value (greater than the lowest negative value) to some positive value.

Ex. instead of 0 to 100
perhaps -25 to 125.

hth

"Aleksandr" wrote:

Hello,

I am trying to create a stacked area Pivot Chart from a Pivot Table. I
have negative values but am having trouble getting them to be
displayed properly in the pivot chart. Currently, the negative values
are displayed at the top and are "eating into" the positive series. I
need the negative values to be displayed below the x-axis. Any help
would be greatly appreciated.
.

On Mar 3, 2:16*am, FloMM2 wrote:
Aleksandr,
*This may be silly to ask, but...
*Did you try and adjust the y-axis scale from 0 to some number to a negative
value (greater than the lowest negative value) to some positive value.

Ex. instead of 0 to 100
perhaps -25 to 125.

hth



"Aleksandr" wrote:
Hello,

I am trying to create a stacked area Pivot Chart from a Pivot Table. I
have negative values but am having trouble getting them to be
displayed properly in the pivot chart. Currently, the negative values
are displayed at the top and are "eating into" the positive series. I
need the negative values to be displayed below the x-axis. Any help
would be greatly appreciated.
.- Hide quoted text -

- Show quoted text -

HTH,
Thanks for the suggestion. I did try that but I think the issue is
that it is a stacked area. When i used a stacked column everything was
displayed as expected. I'm not sure if there is a way to go around
this issue when using a stacked area chart.