software

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.

Don't spend a lot of time looking for every last permutation in the quot;built
in customquot; 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
PeltierTech.com/
_______

quot;Cowtoonquot; gt; wrote in message
...
gt; Help.
gt; I've been asked to create a chart that has two sets of data that are
gt; stacked
gt; (columns) and 5 sets of data that display in line format. Is this an
gt; option
gt; in Excel. I can do a columan and a line but can't seem to add more than
gt; that. I'm using Excel 97 (but have access to Excel 2003).
gt; Please and thanks.
Thanks John.
I didn't realize it would work that way. I'll give it a go.
Thanks so much for your help.
DIana

quot;Jon Peltierquot; wrote:

gt; Don't spend a lot of time looking for every last permutation in the quot;built
gt; in customquot; chart types. What you probably want isn't there, but it's easy to
gt; roll your own type.
gt;
gt; Make a chart with all data plotted in one format (probably line, so you have
gt; to change fewer series). Select a series that you need to switch, and use
gt; Chart Type from the Chart menu to change it to the type you want. Repeat for
gt; the next series you need to change.
gt;
gt; - Jon
gt; -------
gt; Jon Peltier, Microsoft Excel MVP
gt; Peltier Technical Services
gt; Tutorials and Custom Solutions
gt; PeltierTech.com/
gt; _______
gt;
gt; quot;Cowtoonquot; gt; wrote in message
gt; ...
gt; gt; Help.
gt; gt; I've been asked to create a chart that has two sets of data that are
gt; gt; stacked
gt; gt; (columns) and 5 sets of data that display in line format. Is this an
gt; gt; option
gt; gt; in Excel. I can do a columan and a line but can't seem to add more than
gt; gt; that. I'm using Excel 97 (but have access to Excel 2003).
gt; gt; Please and thanks.
gt;
gt;
gt;

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
PeltierTech.com/
_______

quot;Cowtoonquot; gt; wrote in message
...
gt; Thanks John.
gt; I didn't realize it would work that way. I'll give it a go.
gt; Thanks so much for your help.
gt; DIana
gt;
gt; quot;Jon Peltierquot; wrote:
gt;
gt;gt; Don't spend a lot of time looking for every last permutation in the
gt;gt; quot;built
gt;gt; in customquot; chart types. What you probably want isn't there, but it's easy
gt;gt; to
gt;gt; roll your own type.
gt;gt;
gt;gt; Make a chart with all data plotted in one format (probably line, so you
gt;gt; have
gt;gt; to change fewer series). Select a series that you need to switch, and use
gt;gt; Chart Type from the Chart menu to change it to the type you want. Repeat
gt;gt; for
gt;gt; the next series you need to change.
gt;gt;
gt;gt; - Jon
gt;gt; -------
gt;gt; Jon Peltier, Microsoft Excel MVP
gt;gt; Peltier Technical Services
gt;gt; Tutorials and Custom Solutions
gt;gt; PeltierTech.com/
gt;gt; _______
gt;gt;
gt;gt; quot;Cowtoonquot; gt; wrote in message
gt;gt; ...
gt;gt; gt; Help.
gt;gt; gt; I've been asked to create a chart that has two sets of data that are
gt;gt; gt; stacked
gt;gt; gt; (columns) and 5 sets of data that display in line format. Is this an
gt;gt; gt; option
gt;gt; gt; in Excel. I can do a columan and a line but can't seem to add more
gt;gt; gt; than
gt;gt; gt; that. I'm using Excel 97 (but have access to Excel 2003).
gt;gt; gt; Please and thanks.
gt;gt;
gt;gt;
gt;gt;
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

quot;Jon Peltierquot; gt; wrote in message
...
gt; Most people don't realize this. They see the few examples offered by
gt; Excel, and assume that's all there is. Microsoft doesn't always clearly
gt; explain how to use their products to their fullest.
gt;
gt; - Jon
gt; -------
gt; Jon Peltier, Microsoft Excel MVP
gt; Peltier Technical Services
gt; Tutorials and Custom Solutions
gt; PeltierTech.com/
gt; _______
gt;
gt; quot;Cowtoonquot; gt; wrote in message
gt; ...
gt;gt; Thanks John.
gt;gt; I didn't realize it would work that way. I'll give it a go.
gt;gt; Thanks so much for your help.
gt;gt; DIana
gt;gt;
gt;gt; quot;Jon Peltierquot; wrote:
gt;gt;
gt;gt;gt; Don't spend a lot of time looking for every last permutation in the
gt;gt;gt; quot;built
gt;gt;gt; in customquot; chart types. What you probably want isn't there, but it's
gt;gt;gt; easy to
gt;gt;gt; roll your own type.
gt;gt;gt;
gt;gt;gt; Make a chart with all data plotted in one format (probably line, so you
gt;gt;gt; have
gt;gt;gt; to change fewer series). Select a series that you need to switch, and
gt;gt;gt; use
gt;gt;gt; Chart Type from the Chart menu to change it to the type you want. Repeat
gt;gt;gt; for
gt;gt;gt; the next series you need to change.
gt;gt;gt;
gt;gt;gt; - Jon
gt;gt;gt; -------
gt;gt;gt; Jon Peltier, Microsoft Excel MVP
gt;gt;gt; Peltier Technical Services
gt;gt;gt; Tutorials and Custom Solutions
gt;gt;gt; PeltierTech.com/
gt;gt;gt; _______
gt;gt;gt;
gt;gt;gt; quot;Cowtoonquot; gt; wrote in message
gt;gt;gt; ...
gt;gt;gt; gt; Help.
gt;gt;gt; gt; I've been asked to create a chart that has two sets of data that are
gt;gt;gt; gt; stacked
gt;gt;gt; gt; (columns) and 5 sets of data that display in line format. Is this an
gt;gt;gt; gt; option
gt;gt;gt; gt; in Excel. I can do a columan and a line but can't seem to add more
gt;gt;gt; gt; than
gt;gt;gt; gt; that. I'm using Excel 97 (but have access to Excel 2003).
gt;gt;gt; gt; Please and thanks.
gt;gt;gt;
gt;gt;gt;
gt;gt;gt;
gt;
gt;
By the way ... thanks so much for the tip. It worked perfectly. I did it
this morning and it worked wonderfully. Diana

quot;Jon Peltierquot; gt; wrote in message
...
gt; Most people don't realize this. They see the few examples offered by
gt; Excel, and assume that's all there is. Microsoft doesn't always clearly
gt; explain how to use their products to their fullest.
gt;
gt; - Jon
gt; -------
gt; Jon Peltier, Microsoft Excel MVP
gt; Peltier Technical Services
gt; Tutorials and Custom Solutions
gt; PeltierTech.com/
gt; _______
gt;
gt; quot;Cowtoonquot; gt; wrote in message
gt; ...
gt;gt; Thanks John.
gt;gt; I didn't realize it would work that way. I'll give it a go.
gt;gt; Thanks so much for your help.
gt;gt; DIana
gt;gt;
gt;gt; quot;Jon Peltierquot; wrote:
gt;gt;
gt;gt;gt; Don't spend a lot of time looking for every last permutation in the
gt;gt;gt; quot;built
gt;gt;gt; in customquot; chart types. What you probably want isn't there, but it's
gt;gt;gt; easy to
gt;gt;gt; roll your own type.
gt;gt;gt;
gt;gt;gt; Make a chart with all data plotted in one format (probably line, so you
gt;gt;gt; have
gt;gt;gt; to change fewer series). Select a series that you need to switch, and
gt;gt;gt; use
gt;gt;gt; Chart Type from the Chart menu to change it to the type you want. Repeat
gt;gt;gt; for
gt;gt;gt; the next series you need to change.
gt;gt;gt;
gt;gt;gt; - Jon
gt;gt;gt; -------
gt;gt;gt; Jon Peltier, Microsoft Excel MVP
gt;gt;gt; Peltier Technical Services
gt;gt;gt; Tutorials and Custom Solutions
gt;gt;gt; PeltierTech.com/
gt;gt;gt; _______
gt;gt;gt;
gt;gt;gt; quot;Cowtoonquot; gt; wrote in message
gt;gt;gt; ...
gt;gt;gt; gt; Help.
gt;gt;gt; gt; I've been asked to create a chart that has two sets of data that are
gt;gt;gt; gt; stacked
gt;gt;gt; gt; (columns) and 5 sets of data that display in line format. Is this an
gt;gt;gt; gt; option
gt;gt;gt; gt; in Excel. I can do a columan and a line but can't seem to add more
gt;gt;gt; gt; than
gt;gt;gt; gt; that. I'm using Excel 97 (but have access to Excel 2003).
gt;gt;gt; gt; Please and thanks.
gt;gt;gt;
gt;gt;gt;
gt;gt;gt;
gt;
gt;
Glad to help.

- Jonquot;DianaHquot; gt; wrote in message
...
gt; By the way ... thanks so much for the tip. It worked perfectly. I did it
gt; this morning and it worked wonderfully. Diana
gt;
gt; quot;Jon Peltierquot; gt; wrote in message
gt; ...
gt;gt; Most people don't realize this. They see the few examples offered by
gt;gt; Excel, and assume that's all there is. Microsoft doesn't always clearly
gt;gt; explain how to use their products to their fullest.
gt;gt;
gt;gt; - Jon
gt;gt; -------
gt;gt; Jon Peltier, Microsoft Excel MVP
gt;gt; Peltier Technical Services
gt;gt; Tutorials and Custom Solutions
gt;gt; PeltierTech.com/
gt;gt; _______
gt;gt;
gt;gt; quot;Cowtoonquot; gt; wrote in message
gt;gt; ...
gt;gt;gt; Thanks John.
gt;gt;gt; I didn't realize it would work that way. I'll give it a go.
gt;gt;gt; Thanks so much for your help.
gt;gt;gt; DIana
gt;gt;gt;
gt;gt;gt; quot;Jon Peltierquot; wrote:
gt;gt;gt;
gt;gt;gt;gt; Don't spend a lot of time looking for every last permutation in the
gt;gt;gt;gt; quot;built
gt;gt;gt;gt; in customquot; chart types. What you probably want isn't there, but it's
gt;gt;gt;gt; easy to
gt;gt;gt;gt; roll your own type.
gt;gt;gt;gt;
gt;gt;gt;gt; Make a chart with all data plotted in one format (probably line, so you
gt;gt;gt;gt; have
gt;gt;gt;gt; to change fewer series). Select a series that you need to switch, and
gt;gt;gt;gt; use
gt;gt;gt;gt; Chart Type from the Chart menu to change it to the type you want.
gt;gt;gt;gt; Repeat for
gt;gt;gt;gt; the next series you need to change.
gt;gt;gt;gt;
gt;gt;gt;gt; - Jon
gt;gt;gt;gt; -------
gt;gt;gt;gt; Jon Peltier, Microsoft Excel MVP
gt;gt;gt;gt; Peltier Technical Services
gt;gt;gt;gt; Tutorials and Custom Solutions
gt;gt;gt;gt; PeltierTech.com/
gt;gt;gt;gt; _______
gt;gt;gt;gt;
gt;gt;gt;gt; quot;Cowtoonquot; gt; wrote in message
gt;gt;gt;gt; ...
gt;gt;gt;gt; gt; Help.
gt;gt;gt;gt; gt; I've been asked to create a chart that has two sets of data that are
gt;gt;gt;gt; gt; stacked
gt;gt;gt;gt; gt; (columns) and 5 sets of data that display in line format. Is this an
gt;gt;gt;gt; gt; option
gt;gt;gt;gt; gt; in Excel. I can do a columan and a line but can't seem to add more
gt;gt;gt;gt; gt; than
gt;gt;gt;gt; gt; that. I'm using Excel 97 (but have access to Excel 2003).
gt;gt;gt;gt; gt; Please and thanks.
gt;gt;gt;gt;
gt;gt;gt;gt;
gt;gt;gt;gt;
gt;gt;
gt;gt;
gt;
gt;