Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
combination stacked column and line data
Help.
I've been asked to create a chart that has two sets of data that are stacked (columns) and 5 sets of data that display in line format. Is this an option in Excel. I can do a columan and a line but can't seem to add more than that. I'm using Excel 97 (but have access to Excel 2003). Please and thanks. |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
combination stacked column and line data
Don't spend a lot of time looking for every last permutation in the "built
in custom" chart types. What you probably want isn't there, but it's easy to roll your own type. Make a chart with all data plotted in one format (probably line, so you have to change fewer series). Select a series that you need to switch, and use Chart Type from the Chart menu to change it to the type you want. Repeat for the next series you need to change. - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services Tutorials and Custom Solutions http://PeltierTech.com/ _______ "Cowtoon" wrote in message ... Help. I've been asked to create a chart that has two sets of data that are stacked (columns) and 5 sets of data that display in line format. Is this an option in Excel. I can do a columan and a line but can't seem to add more than that. I'm using Excel 97 (but have access to Excel 2003). Please and thanks. |
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
combination stacked column and line data
Thanks John.
I didn't realize it would work that way. I'll give it a go. Thanks so much for your help. DIana "Jon Peltier" wrote: Don't spend a lot of time looking for every last permutation in the "built in custom" chart types. What you probably want isn't there, but it's easy to roll your own type. Make a chart with all data plotted in one format (probably line, so you have to change fewer series). Select a series that you need to switch, and use Chart Type from the Chart menu to change it to the type you want. Repeat for the next series you need to change. - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services Tutorials and Custom Solutions http://PeltierTech.com/ _______ "Cowtoon" wrote in message ... Help. I've been asked to create a chart that has two sets of data that are stacked (columns) and 5 sets of data that display in line format. Is this an option in Excel. I can do a columan and a line but can't seem to add more than that. I'm using Excel 97 (but have access to Excel 2003). Please and thanks. |
#4
Posted to microsoft.public.excel.charting
|
|||
|
|||
combination stacked column and line data
Most people don't realize this. They see the few examples offered by Excel,
and assume that's all there is. Microsoft doesn't always clearly explain how to use their products to their fullest. - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services Tutorials and Custom Solutions http://PeltierTech.com/ _______ "Cowtoon" wrote in message ... Thanks John. I didn't realize it would work that way. I'll give it a go. Thanks so much for your help. DIana "Jon Peltier" wrote: Don't spend a lot of time looking for every last permutation in the "built in custom" chart types. What you probably want isn't there, but it's easy to roll your own type. Make a chart with all data plotted in one format (probably line, so you have to change fewer series). Select a series that you need to switch, and use Chart Type from the Chart menu to change it to the type you want. Repeat for the next series you need to change. - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services Tutorials and Custom Solutions http://PeltierTech.com/ _______ "Cowtoon" wrote in message ... Help. I've been asked to create a chart that has two sets of data that are stacked (columns) and 5 sets of data that display in line format. Is this an option in Excel. I can do a columan and a line but can't seem to add more than that. I'm using Excel 97 (but have access to Excel 2003). Please and thanks. |
#5
Posted to microsoft.public.excel.charting
|
|||
|
|||
combination stacked column and line data
So true. I assumed the same thing and I'm not usually limited by MS's
software, but I certainly was this time. It was soooooo easy to change ... I couldn't believe it. I'm so glad I posted it. Diana "Jon Peltier" wrote in message ... Most people don't realize this. They see the few examples offered by Excel, and assume that's all there is. Microsoft doesn't always clearly explain how to use their products to their fullest. - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services Tutorials and Custom Solutions http://PeltierTech.com/ _______ "Cowtoon" wrote in message ... Thanks John. I didn't realize it would work that way. I'll give it a go. Thanks so much for your help. DIana "Jon Peltier" wrote: Don't spend a lot of time looking for every last permutation in the "built in custom" chart types. What you probably want isn't there, but it's easy to roll your own type. Make a chart with all data plotted in one format (probably line, so you have to change fewer series). Select a series that you need to switch, and use Chart Type from the Chart menu to change it to the type you want. Repeat for the next series you need to change. - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services Tutorials and Custom Solutions http://PeltierTech.com/ _______ "Cowtoon" wrote in message ... Help. I've been asked to create a chart that has two sets of data that are stacked (columns) and 5 sets of data that display in line format. Is this an option in Excel. I can do a columan and a line but can't seem to add more than that. I'm using Excel 97 (but have access to Excel 2003). Please and thanks. |
#6
Posted to microsoft.public.excel.charting
|
|||
|
|||
combination stacked column and line data
By the way ... thanks so much for the tip. It worked perfectly. I did it
this morning and it worked wonderfully. Diana "Jon Peltier" wrote in message ... Most people don't realize this. They see the few examples offered by Excel, and assume that's all there is. Microsoft doesn't always clearly explain how to use their products to their fullest. - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services Tutorials and Custom Solutions http://PeltierTech.com/ _______ "Cowtoon" wrote in message ... Thanks John. I didn't realize it would work that way. I'll give it a go. Thanks so much for your help. DIana "Jon Peltier" wrote: Don't spend a lot of time looking for every last permutation in the "built in custom" chart types. What you probably want isn't there, but it's easy to roll your own type. Make a chart with all data plotted in one format (probably line, so you have to change fewer series). Select a series that you need to switch, and use Chart Type from the Chart menu to change it to the type you want. Repeat for the next series you need to change. - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services Tutorials and Custom Solutions http://PeltierTech.com/ _______ "Cowtoon" wrote in message ... Help. I've been asked to create a chart that has two sets of data that are stacked (columns) and 5 sets of data that display in line format. Is this an option in Excel. I can do a columan and a line but can't seem to add more than that. I'm using Excel 97 (but have access to Excel 2003). Please and thanks. |
#7
Posted to microsoft.public.excel.charting
|
|||
|
|||
combination stacked column and line data
Glad to help.
- Jon "DianaH" wrote in message ... By the way ... thanks so much for the tip. It worked perfectly. I did it this morning and it worked wonderfully. Diana "Jon Peltier" wrote in message ... Most people don't realize this. They see the few examples offered by Excel, and assume that's all there is. Microsoft doesn't always clearly explain how to use their products to their fullest. - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services Tutorials and Custom Solutions http://PeltierTech.com/ _______ "Cowtoon" wrote in message ... Thanks John. I didn't realize it would work that way. I'll give it a go. Thanks so much for your help. DIana "Jon Peltier" wrote: Don't spend a lot of time looking for every last permutation in the "built in custom" chart types. What you probably want isn't there, but it's easy to roll your own type. Make a chart with all data plotted in one format (probably line, so you have to change fewer series). Select a series that you need to switch, and use Chart Type from the Chart menu to change it to the type you want. Repeat for the next series you need to change. - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services Tutorials and Custom Solutions http://PeltierTech.com/ _______ "Cowtoon" wrote in message ... Help. I've been asked to create a chart that has two sets of data that are stacked (columns) and 5 sets of data that display in line format. Is this an option in Excel. I can do a columan and a line but can't seem to add more than that. I'm using Excel 97 (but have access to Excel 2003). Please and thanks. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
creating a bar graph | Excel Discussion (Misc queries) | |||
How do i add a line graph onto a stacked column chart using data | Charts and Charting in Excel | |||
How do I plot both line and column data on same graph? | Charts and Charting in Excel | |||
Line Graph Data Recognition | Charts and Charting in Excel | |||
How do I combine a line and a percentage stacked column chart? | Charts and Charting in Excel |