![]() I’m sure I’d forget at some point too.Īlso, I don’t like how the axis scales are not on the same side of the chart. ![]() What happens if your data changes? You’d need to go back into each axis and reset them. One big drawback for this technique though is that you are forced to hard code the scales. Again, let me emphasize that this is a great technique for Excel. I suspect it would take two minutes or less once you use this technique a few times. It took me a bit over five minutes to create it the first time, but this included flipping back and forth between Excel and the instructions. In Jon’s post, I quickly counted about 13 steps (I think there are more I lost count as I recreated the chart), but there are many clicks for each of these steps. I wouldn’t exactly call this technique easy. Seems pretty straight forward, right? Well not exactly. In this post Jon walks you through how to create this chart in Excel: He always has great tips for getting things done in Excel and his recent post “ Easy Two-Panel Column Chart in Excel” is no exception.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |