testing for 90percentexcel.xlsx
Good morning I am hoping somebody maybe able to help me with the attached, I am trying to show current work and up and coming work compared to available man hours.
this would mean the green bar up against a stacked red and brown bar.
I have searched the internet for answers however the only thing I have found is to change the bar chart to a stacked bar chart with all three values together.
Please could somebody show me the errors of my ways
Regards
Steve
Does the attached help - using the 2nd y axis
Richard Buttrey
RIP - d. 06/10/2022
If any of the responses have helped then please consider rating them by clicking the small star iconbelow the post.
Richard thank you ever so much, how do you add a second y axis.
Hi,
Select the series in question (e.g. right click on it), choose Format Data series and then select the 'Plot Series On' option and select 2nd y axis
Just realised that the two axes are not the same scale.....back shortly
...revised axis scale
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks