combination area and line needed
I am using '03, and need a chart that has a few series in area buildup view
(filled sections which build on top of themselves), with one other series that appears over that area as a line. Any help? Thx. -- Boris |
Plot all series together in a stacked area chart. Select the series you
want converted to a line, go to Chart Type on the Chart menu, and select the chart type you want. - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services Tutorials and Custom Solutions http://PeltierTech.com/ _______ BorisS wrote: I am using '03, and need a chart that has a few series in area buildup view (filled sections which build on top of themselves), with one other series that appears over that area as a line. Any help? Thx. |
very nice. So I take it that this it the way to do all combinations? Get
the base (majority) done first, then just take any one series and convert it to a different type? Can you do more than two types on a chart? If so, is there a limit? This is great. Opens up quite a set of possibilities for getting creative. Does second axis pose a problem in these cases, if converting to that? Any sorts of tips to avoid? Thx so much. -- Boris "Jon Peltier" wrote: Plot all series together in a stacked area chart. Select the series you want converted to a line, go to Chart Type on the Chart menu, and select the chart type you want. - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services Tutorials and Custom Solutions http://PeltierTech.com/ _______ BorisS wrote: I am using '03, and need a chart that has a few series in area buildup view (filled sections which build on top of themselves), with one other series that appears over that area as a line. Any help? Thx. |
Boris -
I always tell people not to use the limited selection of "built-in custom" charts that Excel offers, but to build their own this way. Some chart types do not accommodate combinations, most notably those with 3D effects (another good reason to avoid charts with 3D effects), and also bubble charts. But you can combine pretty much any other types. Here's an article about combination charts and a list of examples: http://peltiertech.com/Excel/Charts/ComboCharts.html - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services Tutorials and Custom Solutions http://PeltierTech.com/ _______ BorisS wrote: very nice. So I take it that this it the way to do all combinations? Get the base (majority) done first, then just take any one series and convert it to a different type? Can you do more than two types on a chart? If so, is there a limit? This is great. Opens up quite a set of possibilities for getting creative. Does second axis pose a problem in these cases, if converting to that? Any sorts of tips to avoid? Thx so much. |
John, excellent advice. Thanks much. Is there, by chance, a way to save the
chart types I make? In other words, is the custom list something that can be built upon? I guess it's maybe a moot point, considering the advice that building from scratch and adjusting seems the way to go, but just thought I'd ask. Thanks again. -- Boris "Jon Peltier" wrote: Boris - I always tell people not to use the limited selection of "built-in custom" charts that Excel offers, but to build their own this way. Some chart types do not accommodate combinations, most notably those with 3D effects (another good reason to avoid charts with 3D effects), and also bubble charts. But you can combine pretty much any other types. Here's an article about combination charts and a list of examples: http://peltiertech.com/Excel/Charts/ComboCharts.html - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services Tutorials and Custom Solutions http://PeltierTech.com/ _______ BorisS wrote: very nice. So I take it that this it the way to do all combinations? Get the base (majority) done first, then just take any one series and convert it to a different type? Can you do more than two types on a chart? If so, is there a limit? This is great. Opens up quite a set of possibilities for getting creative. Does second axis pose a problem in these cases, if converting to that? Any sorts of tips to avoid? Thx so much. |
Sorry. Jon, not John.
-- Boris "Jon Peltier" wrote: Boris - I always tell people not to use the limited selection of "built-in custom" charts that Excel offers, but to build their own this way. Some chart types do not accommodate combinations, most notably those with 3D effects (another good reason to avoid charts with 3D effects), and also bubble charts. But you can combine pretty much any other types. Here's an article about combination charts and a list of examples: http://peltiertech.com/Excel/Charts/ComboCharts.html - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services Tutorials and Custom Solutions http://PeltierTech.com/ _______ BorisS wrote: very nice. So I take it that this it the way to do all combinations? Get the base (majority) done first, then just take any one series and convert it to a different type? Can you do more than two types on a chart? If so, is there a limit? This is great. Opens up quite a set of possibilities for getting creative. Does second axis pose a problem in these cases, if converting to that? Any sorts of tips to avoid? Thx so much. |
Boris -
You can save a custom chart type, and use it like the standard or built in chart types: http://peltiertech.com/Excel/ChartsH...stomTypes.html - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services Tutorials and Custom Solutions http://PeltierTech.com/ _______ BorisS wrote: John, excellent advice. Thanks much. Is there, by chance, a way to save the chart types I make? In other words, is the custom list something that can be built upon? I guess it's maybe a moot point, considering the advice that building from scratch and adjusting seems the way to go, but just thought I'd ask. Thanks again. |
All times are GMT +1. The time now is 04:18 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com