Charts: Can't exit formula bar when editing series

[nigelk]

Hi all,


Excel 2007


I'm trying out some dynamic charts, and the instructions on the web site say you can click on the series and edit the source in the formula bar.

However, when I do this, I can't exit the formula bar (pressing enter does not work)

Can anyone help?

Thanks,Nigel

 

[Akashwani]

Hi Nigel,

Have you tried clicking in a cell on your worksheet?

Ak

 

[nigelk]

Hi Akashwani,

I can't select any cell.

But if I make a typo in the formula bar, Excel lets me know, but when I correct it, then I'm back to square one.

Thanks,Nigel

 

[VoG]

I think that this means that you are not entering a valid series. Pressing ESC should get you back to square one.

 

[nigelk]

Hi Vog,

I didn't mention that the series comes from named ranges. However, I have one chart that works perfect, but click on the series, try to edit in the formula bar, no luck.

But if I change it to a unknown named range, then it does recognise that it is an invalid name.

Nigel

 

[Akashwani]

Hi Nigel,

Can you post the link to the website so I can try and recreate your situation?

Thanks

Ak

 

[nigelk]

http://peltiertech.com/Excel/Charts/DynamicCharts.html

There's a link at the bottom where you can download an example.

On the second sheet ( called examples), click on any chart series, then click in the formula bar.

Pressing 'enter' will not get you out.

Nigel

 

[Akashwani]

Hi Nigel,

I pressed esc then clicked in a cell and managed to get out of the formula bar.

Ak

 

[nigelk]

Did you find a way of editing it?

Thanks,Nigel

 

[Akashwani]

Hi Nigel,

How do you want to edit the series?
If you are referring to a named range within the series then surely you change the range the Named Range refers to.

If you want to edit/delete an existing series and change it to a new one.
Click on the chart, on the ribbon click Design, click Data Series, click Edit, highlight the Named Range part of the formula, press F3 and click on the new Named Range that you want to use.

Other than that I'm not sure what you can do.

Good luck

Ak