Creating secondary y-axis on bar chart

V

vviswanathan

New member
Joined
May 16, 2016
Messages
1
Reaction score
0
Points
0
Hello,

Does anyone know how to add a y-axis on the left of the chart that would measure the corresponding dollar value of the segments composing the bar? I'd like the finish product to appear like a single stacked bar measuring % on the left and market value on the right.

Thanks,
Vijay
 

Attachments

  • Capture.PNG
    Capture.PNG
    12.6 KB · Views: 21
  • Excel chart to add y-axis (market value).xlsx
    9.8 KB · Views: 10
Hi,
you can add a dummy series to secondary axe as column chart.
Value of column = 100% market value. Make it transparent and there you go :)
 
You must log in or register to reply here.
Back
Top