Editing a series in the formula bar

E

exceluser

When I edit a chart's series in the formula bar, hitting Enter doesn't
commit the change.

Is there an obvious reason as to why that would happen ?

For example, the series I want to change is the following:

=SERIES(DataSheet!$B$1,DataSheet!$A$2:$A$32,DataSheet!$B$2:$B$32,1)

I'm trying to change it to the following:

=SERIES(DataSheet!$B$1,Normalized.xls!rngDates,Normalized.xls!
rngValue1,1)

This is an example from:

http://peltiertech.com/Excel/ChartsHowTo/DynamicNormalized.html



Exceluser
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Adding sequence numbers to paragraphs 0
Can you input multiple series names and values with a single definedname ? 0
Dynamic series in rows 1
Chart SERIES OFFSET 5
Finding the right style field in VBA 0
Paste new SERIES() in formula bar 2
Formating bolded text exclusively. 0
sideways stacked bar charts with line series on the same axis 0

Top