Multiiple graphs

I have 5 variables with over time for 10 regions. I was trying create 10
graphs representing each region on a single chart like Quattro Pro. I
thought earlier versions of excel had that option.

----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.

http://www.microsoft.com/office/comm...excel.charting

You can certainly create a chart with multiple series. If the original data
range contains one set of categories and multiple sets of values, all of the
values will be plotted against the same categories. If the category values
are different, you can make the chart with the first series, then select and
copy the range with X and Y values for a subsequent series, and use Paste
Special from the Edit menu to add the data as a new series.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______


"ageconss" <[email protected]> wrote in message
news:[email protected]...
>I have 5 variables with over time for 10 regions. I was trying create 10
> graphs representing each region on a single chart like Quattro Pro. I
> thought earlier versions of excel had that option.
>
> ----------------
> This post is a suggestion for Microsoft, and Microsoft responds to the
> suggestions with the most votes. To vote for this suggestion, click the "I
> Agree" button in the message pane. If you do not see the button, follow
> this
> link to open the suggestion in the Microsoft Web-based Newsreader and then
> click "I Agree" in the message pane.
>
> http://www.microsoft.com/office/comm...excel.charting