Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Paste new SERIES() in formula bar
I want to consolidate pairs of charts into one chart with two series, call
them A and B. Rather than doing the work all over to add series B to chart A, I would simply like to copy B's SERIES() function in the formula bar and paste it into A's formula bar. While working in a formula bar is often a convenient way to change an existing series, I have not found a way to add a new series to a chart. Can it be done, and how? |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
Paste new SERIES() in formula bar
Copy the series formula, select the plot area of the other chart, click in
the formula bar, paste the series formula, and click Enter. Note, if this series formula is for series 1, it will take position 1 in the new chart, moving the other series back in the order. However, before you click Enter, you can edit the pasted formula, so change to a higher plot index). An alternative is to copy one chart, select the second, and use Paste Special with the Formulas option. This pastes all series in the copied chart after all series in the chart they are pasted into. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "hmm" wrote in message ... I want to consolidate pairs of charts into one chart with two series, call them A and B. Rather than doing the work all over to add series B to chart A, I would simply like to copy B's SERIES() function in the formula bar and paste it into A's formula bar. While working in a formula bar is often a convenient way to change an existing series, I have not found a way to add a new series to a chart. Can it be done, and how? |
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
Paste new SERIES() in formula bar
If you go into A, the up and down arrow keys will step through the various
series in the chart, and also through things like chart area and plot area. If you do that so that the formula bar is blank and so that the name box to the left of the formula bar is showing something like chart area or plot area, then if you paste B's SERIES() function into the formula bar it will add that as an extra series to chart A. -- David Biddulph "hmm" wrote in message ... I want to consolidate pairs of charts into one chart with two series, call them A and B. Rather than doing the work all over to add series B to chart A, I would simply like to copy B's SERIES() function in the formula bar and paste it into A's formula bar. While working in a formula bar is often a convenient way to change an existing series, I have not found a way to add a new series to a chart. Can it be done, and how? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
I want to paste in new POINTS, not a new SERIES, from another workbook | Charts and Charting in Excel | |||
Series Formula Help | Excel Worksheet Functions | |||
series graph -- one series being added to another series | Charts and Charting in Excel | |||
Series Formula | Excel Discussion (Misc queries) | |||
animate by series an Excel chart that's paste-linked into Powerpo. | Charts and Charting in Excel |