I have many variables with the same time scale, Is there any way to create a grouped chart in Excel?
Something like this:
Super User is a question and answer site for computer enthusiasts and power users. It only takes a minute to sign up.Sign up to join this community
This is actually three separate graphs placed one above the other with a few things turned on and off and and a little bit of sideways stretching by eye to get the vertical gridlines to align. Even after doing this, there are a few problems.
The vertical gridlines are not perfectly aligned
The values of the Y-axis overlap and cause a reading issue.
Series legend cannot be at the bottom for all three graphs or even together unless you do a little trickery
your time scales limits (X-axis) need to be the same for all graphs
There can be nothing behind the graphs as the graph backgrounds are transparent
The graphs cannot be placed on their own tab, they need to stay on a worksheet
you need to check repeatedly that the graphs remain vertically aligned as they are subject to dynamic changes in scales as data, series' names change
If this manual method works for you I can expand on the answer in order to achieve similar results.