Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
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 |
#2
Posted to microsoft.public.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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel changing number formatting and source data in graphs on it's own!!! | Excel Discussion (Misc queries) | |||
Removing 0 or none 0 values from graphs | Charts and Charting in Excel | |||
hiding and showing graphs | Excel Worksheet Functions | |||
Help! My graphs sneezed! | Charts and Charting in Excel | |||
graphs showing unwanted zero values | Excel Discussion (Misc queries) |