Excel Charts

B

Big Gray Cat

Folks ---

I can create a chart using the chart wizard rather easily.

HOWEVER, when I try to rename the "Series 1" or "Series 2" names in the
legend to something useful, I get a pop-up diagnostic that reads: "A formula
in this worksheet contains one or more invalid references. Verify that your
formulas [sic] contain a valid path, workbook, range name, and cell
reference."

Hmmm.

It appears that I'm exceeding the capacity of what appears to be a data
entry field that the wizard's using to set up the chart. If I leave the
"Series" names, I'm fine.
Anything else, and I go off the rails. All I can do is hit "Cancel."

Thankx in advance from The Big Gray Cat\
 
J

Jon Peltier

How are you trying to rename the series?

Right click the chart, select Source Data, click on the Series tab, select
the series, then either type something in the Name box, or click in the name
box and select a cell containing the name.

- Jon
 
B

Big Gray Cat

Jon ---

I did exactly as specified, and when I got to "Click on the Series Tab,"
the exact same diagnostic popped up. At this point all I can do is hit
"Cancel" and be done with it.

Am I exceeding the capacity of this system? Do I need to do anything to
this XP system I'm running on?

Thankx in advance from The Big Gray Cat

------------------------------------------------------------------------------------------------

Jon Peltier said:
How are you trying to rename the series?

Right click the chart, select Source Data, click on the Series tab, select
the series, then either type something in the Name box, or click in the name
box and select a cell containing the name.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


Big Gray Cat said:
Folks ---

I can create a chart using the chart wizard rather easily.

HOWEVER, when I try to rename the "Series 1" or "Series 2" names in the
legend to something useful, I get a pop-up diagnostic that reads: "A
formula
in this worksheet contains one or more invalid references. Verify that
your
formulas [sic] contain a valid path, workbook, range name, and cell
reference."

Hmmm.

It appears that I'm exceeding the capacity of what appears to be a data
entry field that the wizard's using to set up the chart. If I leave the
"Series" names, I'm fine.
Anything else, and I go off the rails. All I can do is hit "Cancel."

Thankx in advance from The Big Gray Cat\
 
J

Jon Peltier

This error pops up when you click on the series tab? Is a range on display
in the Data Range tab? What ranges are you trying to use. Can you edit the
series formula directly?

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______



Big Gray Cat said:
Jon ---

I did exactly as specified, and when I got to "Click on the Series Tab,"
the exact same diagnostic popped up. At this point all I can do is hit
"Cancel" and be done with it.

Am I exceeding the capacity of this system? Do I need to do anything to
this XP system I'm running on?

Thankx in advance from The Big Gray Cat

------------------------------------------------------------------------------------------------

Jon Peltier said:
How are you trying to rename the series?

Right click the chart, select Source Data, click on the Series tab,
select
the series, then either type something in the Name box, or click in the
name
box and select a cell containing the name.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


Big Gray Cat said:
Folks ---

I can create a chart using the chart wizard rather easily.

HOWEVER, when I try to rename the "Series 1" or "Series 2" names in the
legend to something useful, I get a pop-up diagnostic that reads: "A
formula
in this worksheet contains one or more invalid references. Verify that
your
formulas [sic] contain a valid path, workbook, range name, and cell
reference."

Hmmm.

It appears that I'm exceeding the capacity of what appears to be a data
entry field that the wizard's using to set up the chart. If I leave
the
"Series" names, I'm fine.
Anything else, and I go off the rails. All I can do is hit "Cancel."

Thankx in advance from The Big Gray Cat\
 

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

Top