Excel 2013
I have a 100% stacked Bar Chart that displays the % time spent on particular tasks hour by hour during a 24 hour time frame, therefore my chart has 24 stacked columns. However, I would like the x-axis be labeled 0 to 23 and not 1 to 24.
Excel 2013
I have a 100% stacked Bar Chart that displays the % time spent on particular tasks hour by hour during a 24 hour time frame, therefore my chart has 24 stacked columns. However, I would like the x-axis be labeled 0 to 23 and not 1 to 24.
can you upload a sample workbook?
Hope I could help - if your post has been solved don't forget to mark it as such.
Clicking the * below is a great way to say thanks!
"Drowning in 10 feet of water isn?t any different than drowning in a million feet. And if you can swim, it doesn?t matter how deep the ocean is. At some level, once you realize you?re in water that?s too deep to stand, you have to have a very different approach," - Joi Ito
Please find workbook attached.
Use the select data dialog to set the Horizontal axis (Category) range to =Monitor!$B$7:$Y$7
It's been so long since my last post. How do I mark this as SOLVED?
Please select Thread Tools from the menu link above and mark this thread as SOLVED.
If that's not enough a bit more detailed description (with second option) is near the bottom of http://www.excelforum.com/forum-rule...rum-rules.html
Best Regards,
Kaper
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks