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 |
Multiiple graphs
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" wrote in message ... 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 |
All times are GMT +1. The time now is 11:14 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com