Charting - solid bar & stacked bar
Hello,
While I have used Excel, I have rarely created any charts. Our company allows one to carry over paid time off into the next year, but it must be used before end of that year. I have data calculated by dept: sales, ops, finance. Each has total days, used days and remaining days.
Is it possible to create 1 solid bar for total days with a stacked bar for used/remaining for by dept?
I can only get solid bars for each grouped by dept.
TIA,
Regards,
Jan
Attach a sample workbook. Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.
Remember to desensitize the data.
Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.
One spreadsheet to rule them all. One spreadsheet to find them. One spreadsheet to bring them all and at corporate, bind them.
A picture is worth a thousand words, but a sample spreadsheet is more likely to be worked on.
It's all about the data layout. Use stacked column.
Alternative is a simple stacked Used/Remain with additional Total on secondary axis used to display data value
Hi Andy,
You hit the nail on the head of what I want to accomplish. I just can't figure out how you did it. How do I change the used and remaining to a stack bar?
I've attached my data. I don't think my format would matter, but I may be wrong.
TIA,
Kind regards,
Jan
Select Used series and move to secondary axis
report for Remaining
Change chart type for Used series to Stacked column
Thank you for directing me where to change it. It works. I'm so happy.
Regards,
Jan
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks