Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel Charts
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\ |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel Charts
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" wrote in message ... 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\ |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel Charts
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" wrote: 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" wrote in message ... 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\ |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel Charts
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" wrote in message ... 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" wrote: 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" wrote in message ... 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\ |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
link excel charts to web pages and update charts automatically | Charts and Charting in Excel | |||
Charts - How to have multiple charts share a legend. | Charts and Charting in Excel | |||
interactive charts for stacked bar charts | Charts and Charting in Excel | |||
Matching the colors Column Charts and Pie Charts | Charts and Charting in Excel | |||
Issues copying excel charts to word documents - using Excel VBA | Excel Worksheet Functions |