Chart Question

[chef]

Hi,

Is it possible to creat a bar chart and mirror the values to the left of the Y axis , as well as the right.

Any ideas?

regards
chef

 

[dangre]

I'm pretty certain you can accomplish this by copying your chart, then formatting the Value Axis:

Right-click on Y Axis labels, choose Format Axis, Scale Tab, choose Values in Reverse Order.

 

[chef]

Chart

Tried that but it doesnt mirror the values,puts them in reverse order but out of sync with other chart.

Thanks for the replay tho.

I'm wracking my brains and cant think of a solution

regards
chef

 

[indiantrix]

Sample data:
Females Male
Monday -13% 10%
Tuesday -15% 11%
Wednesday-16% 12%
Thursday -19% 13%
Friday -17% 15%
Saturday -11% 20%
Sunday -9% 19%

1. Select data, chart wizard, bar chart (first type in selection area)
2. Format y-axis (in middle of chart), patterns tab, Tickmark labels=LOW
3. Rt-clk on x-axis, format Number to Custom 0%;0%;0%
4. Stretch chart to see all values.
5. If desired, rt-clk on a bar, format series, options, change settings.
Hope this helps you with the situation. Please note, for "mirror" displays, one series has to be negative, while the other is positive.
/s/ Larry

 

[tusharm]

Plot the data series twice. Then, move one of the plotted series to the secondary axis (in the chart, double-click the series, then select the Axis tab, and in there select the option for Secondary Axis).

Hi,

Is it possible to creat a bar chart and mirror the values to the left of the Y axis , as well as the right.

Any ideas?

regards
chef