Chart Question

chef

Well-known Member
Joined
Jul 10, 2002
Messages
561
Office Version
  1. 365
  2. 2016
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
 

Excel Facts

Waterfall charts in Excel?
Office 365 customers have access to Waterfall charts since late 2016. They were added to Excel 2019.

dangre

Board Regular
Joined
May 27, 2002
Messages
134
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

Well-known Member
Joined
Jul 10, 2002
Messages
561
Office Version
  1. 365
  2. 2016
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

Well-known Member
Joined
Oct 17, 2002
Messages
943
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

MrExcel MVP
Joined
May 28, 2002
Messages
11,029
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
 

Forum statistics

Threads
1,136,594
Messages
5,676,700
Members
419,644
Latest member
KeelsM

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top