View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.charting
hmm hmm is offline
external usenet poster
 
Posts: 175
Default 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?