Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Create an identical Chart Worksheet in Excel 2003
Hi:
I used the F11 key to create a chart, which inserts just a chart as a new worksheet and gives it a default name, such as chart 2. My question is, can I create an identical chart as a new worksheet. This wouldn't be a copy, rather, a duplicate that is pulling information from the same location in the entire workbook. The reason I want to do this is because I currently have data for 12 different series, and each series has 7 values. What I would like to do is keep the same chart, but reduce the number of values per series from 7 to just 4. The easiest way seems to me to be to create duplicate chart and then alter the range of values for each series from 7 data points to just 4. Is this doable? If not, is there another way to accomplish this without building a new chart from scratch. I want to retain my current chart with all 7 values. Thanks, Brooks |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
Create an identical Chart Worksheet in Excel 2003
Of course, just select the chart sheet, right-click the chart tab, select
Move or Copy from the list, then pick your chart sheet from the list, check the Create A Copy box, and away you go. -- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "Brooks" wrote in message ... Hi: I used the F11 key to create a chart, which inserts just a chart as a new worksheet and gives it a default name, such as chart 2. My question is, can I create an identical chart as a new worksheet. This wouldn't be a copy, rather, a duplicate that is pulling information from the same location in the entire workbook. The reason I want to do this is because I currently have data for 12 different series, and each series has 7 values. What I would like to do is keep the same chart, but reduce the number of values per series from 7 to just 4. The easiest way seems to me to be to create duplicate chart and then alter the range of values for each series from 7 data points to just 4. Is this doable? If not, is there another way to accomplish this without building a new chart from scratch. I want to retain my current chart with all 7 values. Thanks, Brooks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
HOW TO CREATE 2 IDENTICAL INVOICES ON 1 A4 SHEET | New Users to Excel | |||
Create an Identical Worksheet | Excel Discussion (Misc queries) | |||
How do I create a Gantt chart using Excel 2003? | Excel Discussion (Misc queries) | |||
How do I create a Gantt Chart in Excel 2003? | Charts and Charting in Excel | |||
How do I create a MAP graph/chart in EXCEL 2003? | Charts and Charting in Excel |