It is possible to create grouped charts in Excel?
up vote
2
down vote
favorite
I have many variables with the same time scale, Is there any way to create a grouped chart in Excel?
Something like this:
microsoft-excel charts
edited Nov 23 at 17:25
cybernetic.nomad
1,107111
asked Nov 23 at 15:52
Roga Lu
112
New contributor
Roga Lu is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
add a comment |
up vote
2
down vote
favorite
I have many variables with the same time scale, Is there any way to create a grouped chart in Excel?
Something like this:
microsoft-excel charts
edited Nov 23 at 17:25
cybernetic.nomad
1,107111
asked Nov 23 at 15:52
Roga Lu
112
New contributor
Roga Lu is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
not by default. You could manually arrange 3 separate graph to line up and sit on top of one another, but there is nothing built in that automatically does it as far as I know.
– Forward Ed
Nov 23 at 16:30
@Roga Lu, once I've had created Column Chart in group for Weekly data. First Convert Data into Table so that Excel will automatically include chart for New Group. Then Select data and choose Clustered Column Chart type.
– Rajesh S
Nov 24 at 9:21
@Roga Lu,, another is Create Pivot Table Chart after you group the data. Hope either methods will help you !!
– Rajesh S
Nov 24 at 9:22
add a comment |
up vote
2
down vote
favorite
up vote
2
down vote
favorite
I have many variables with the same time scale, Is there any way to create a grouped chart in Excel?
Something like this:
microsoft-excel charts
edited Nov 23 at 17:25
cybernetic.nomad
1,107111
asked Nov 23 at 15:52
Roga Lu
112
New contributor
Roga Lu is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
I have many variables with the same time scale, Is there any way to create a grouped chart in Excel?
Something like this:
microsoft-excel charts
microsoft-excel charts
edited Nov 23 at 17:25
cybernetic.nomad
1,107111
asked Nov 23 at 15:52
Roga Lu
112
New contributor
Roga Lu is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
edited Nov 23 at 17:25
cybernetic.nomad
1,107111
asked Nov 23 at 15:52
Roga Lu
112
New contributor
Roga Lu is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
edited Nov 23 at 17:25
cybernetic.nomad
1,107111
edited Nov 23 at 17:25
cybernetic.nomad
1,107111
edited Nov 23 at 17:25
cybernetic.nomad
1,107111
1,107111
asked Nov 23 at 15:52
Roga Lu
112
New contributor
Roga Lu is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
asked Nov 23 at 15:52
Roga Lu
112
asked Nov 23 at 15:52
Roga Lu
112
112
New contributor
Roga Lu is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
New contributor
Roga Lu is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
Roga Lu is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
not by default. You could manually arrange 3 separate graph to line up and sit on top of one another, but there is nothing built in that automatically does it as far as I know.
– Forward Ed
Nov 23 at 16:30
@Roga Lu, once I've had created Column Chart in group for Weekly data. First Convert Data into Table so that Excel will automatically include chart for New Group. Then Select data and choose Clustered Column Chart type.
– Rajesh S
Nov 24 at 9:21
@Roga Lu,, another is Create Pivot Table Chart after you group the data. Hope either methods will help you !!
– Rajesh S
Nov 24 at 9:22
add a comment |
not by default. You could manually arrange 3 separate graph to line up and sit on top of one another, but there is nothing built in that automatically does it as far as I know.
– Forward Ed
Nov 23 at 16:30
@Roga Lu, once I've had created Column Chart in group for Weekly data. First Convert Data into Table so that Excel will automatically include chart for New Group. Then Select data and choose Clustered Column Chart type.
– Rajesh S
Nov 24 at 9:21
@Roga Lu,, another is Create Pivot Table Chart after you group the data. Hope either methods will help you !!
– Rajesh S
Nov 24 at 9:22
not by default. You could manually arrange 3 separate graph to line up and sit on top of one another, but there is nothing built in that automatically does it as far as I know.
– Forward Ed
Nov 23 at 16:30
not by default. You could manually arrange 3 separate graph to line up and sit on top of one another, but there is nothing built in that automatically does it as far as I know.
– Forward Ed
Nov 23 at 16:30
@Roga Lu, once I've had created Column Chart in group for Weekly data. First Convert Data into Table so that Excel will automatically include chart for New Group. Then Select data and choose Clustered Column Chart type.
– Rajesh S
Nov 24 at 9:21
@Roga Lu, once I've had created Column Chart in group for Weekly data. First Convert Data into Table so that Excel will automatically include chart for New Group. Then Select data and choose Clustered Column Chart type.
– Rajesh S
Nov 24 at 9:21
@Roga Lu,, another is Create Pivot Table Chart after you group the data. Hope either methods will help you !!
– Rajesh S
Nov 24 at 9:22
@Roga Lu,, another is Create Pivot Table Chart after you group the data. Hope either methods will help you !!
– Rajesh S
Nov 24 at 9:22
add a comment |
1 Answer
1
active
oldest
votes
up vote
0
down vote
To the best of my knowledge there is no built in automatic way to do this. Manually and with a little bit of eyeballing it, you can achieve the following:
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.
answered Nov 23 at 17:09
Forward Ed
437213
add a comment |
1 Answer
1
active
oldest
votes
1 Answer
1
active
oldest
votes
active
oldest
votes
active
oldest
votes
up vote
0
down vote
To the best of my knowledge there is no built in automatic way to do this. Manually and with a little bit of eyeballing it, you can achieve the following:
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.
answered Nov 23 at 17:09
Forward Ed
437213
add a comment |
up vote
0
down vote
To the best of my knowledge there is no built in automatic way to do this. Manually and with a little bit of eyeballing it, you can achieve the following:
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.
answered Nov 23 at 17:09
Forward Ed
437213
add a comment |
up vote
0
down vote
up vote
0
down vote
To the best of my knowledge there is no built in automatic way to do this. Manually and with a little bit of eyeballing it, you can achieve the following:
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.
answered Nov 23 at 17:09
Forward Ed
437213
To the best of my knowledge there is no built in automatic way to do this. Manually and with a little bit of eyeballing it, you can achieve the following:
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.
answered Nov 23 at 17:09
Forward Ed
437213
edited Nov 23 at 18:35
answered Nov 23 at 17:09
Forward Ed
437213
answered Nov 23 at 17:09
Forward Ed
437213
answered Nov 23 at 17:09
Forward Ed
437213
437213
add a comment |
add a comment |
Roga Lu is a new contributor. Be nice, and check out our Code of Conduct.
Roga Lu is a new contributor. Be nice, and check out our Code of Conduct.
Roga Lu is a new contributor. Be nice, and check out our Code of Conduct.
Roga Lu is a new contributor. Be nice, and check out our Code of Conduct.
Thanks for contributing an answer to Super User!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Some of your past answers have not been well-received, and you're in danger of being blocked from answering.
Please pay close attention to the following guidance:
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fsuperuser.com%2fquestions%2f1377842%2fit-is-possible-to-create-grouped-charts-in-excel%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
not by default. You could manually arrange 3 separate graph to line up and sit on top of one another, but there is nothing built in that automatically does it as far as I know.
– Forward Ed
Nov 23 at 16:30
@Roga Lu, once I've had created Column Chart in group for Weekly data. First Convert Data into Table so that Excel will automatically include chart for New Group. Then Select data and choose Clustered Column Chart type.
– Rajesh S
Nov 24 at 9:21
@Roga Lu,, another is Create Pivot Table Chart after you group the data. Hope either methods will help you !!
– Rajesh S
Nov 24 at 9:22