Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Create multiple Charts from one worksheet
Hello All,
I have a worksheet that I use as my "main" worksheet that is linked to several more worksheets where the information after calculations is populated.(The other worksheets are 'read only' and emailed to others.) I have been asked to graph the trends of several items in my main worksheet. This metrics worksheet is re-used each month and then saved as a monthly file. How can I copy the raw data from my main worksheet from each month without coping the links? How can I compile each month to create the graphs for trend purposes? Also creating multiple graphs. |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
Create multiple Charts from one worksheet
How can I copy the raw data from my main worksheet from each month without coping the links? Copy - Paste Special - Values How can I compile each month to create the graphs for trend purposes? Copy the data from the separate sheets, paste values onto the summary worksheet, and the charts linked to the summary worksheet will update. Also creating multiple graphs. Don't know what you're asking. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ |
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
Create multiple Charts from one worksheet
Creating Multiple graphs question - From the main worksheet I am asked to
create 4 differant graphs using different column of data. Should I pose this question under "graphs" ? "Jon Peltier" wrote: How can I copy the raw data from my main worksheet from each month without coping the links? Copy - Paste Special - Values How can I compile each month to create the graphs for trend purposes? Copy the data from the separate sheets, paste values onto the summary worksheet, and the charts linked to the summary worksheet will update. Also creating multiple graphs. Don't know what you're asking. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Macro to create multiple charts? | Charts and Charting in Excel | |||
Create multiple XY scatter charts | Charts and Charting in Excel | |||
How can I create multiple charts using variable data? | Charts and Charting in Excel | |||
Use a loop to create multiple Charts - Suggestions ? | Charts and Charting in Excel | |||
Create Multiple Charts w/ VB | Charts and Charting in Excel |