Hi,
I would like to create the bar graph by comparing the plan with the completion. I would like to show the completion in year 2023 and 2024 by having the year 2024 stack on year 2023 and compare with the whole plan.
Can you please advise how to get this done?
I also attached the file that i am trying to work with.
Thank you very much the support and guidance.
Regard,
You need to alter the layout of your data
Move the 2 year series to secondary axis and change to stacked column.
Adjust the gap width of series on primary and secondary axis
Use multi level category axis labeling to get it centered under each set of data points
ooh, thanks. Your advice help me to done my task!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks