Hi. I'm trying to make a column chart (see below image) that I can use the day and date from each week's columns from table below and the column chart will show the day/date along the horizontal axis directly under each bar. For example the first blue bar should have THU 7/2/20 and the next Orange bar should have THU 7/9/20 so it's easier to compare and graph. I can't find an option for this in excel. Any help would be much appreciated. Thanks.
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
Column Chart Question
- Thread starter tmk0427
- Start date
Jon Peltier
MrExcel MVP
- Joined
- May 14, 2003
- Messages
- 5,318
- Office Version
- 365
- Platform
- Windows
- MacOS
Well, to me your chart looks fine.
But you can rearrange the data differently to get the labels along the X axis. You can do it as a single series (one color columns)
Or you can do it as two series (different colors for each week)
But you can rearrange the data differently to get the labels along the X axis. You can do it as a single series (one color columns)
Or you can do it as two series (different colors for each week)
Upvote
0
Similar threads
- Solved
- Question
