Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.charting
|
|||
|
|||
![]()
I had a workbook of data with a number of graphs in one worksheet; each
graph series was populated by a named range (A_, B_, C_, D_, etc.). A_ was the only direct (actually, indirect) reference, and the other series are all offsets of A_ I had some new data in a new workbook, so I used the worksheet/copy/move functionality to make a copy of the worksheet that contains the graphs in my new workbook. I copied over the named ranges and re-set them in my new workbook to the new data areas (and verified that they accurately point to ranges of data- which they do). However, the 'new' graphs do not want to accept the named ranges in the new workbook. Workbook name: "v10.xls" Named Range for the first graph= "A_" which worked fine in the old workbook In the new workbook, I click on source data for the first graph and click into the source data fields; just like with the old workbook, the only one populated is Series1 as =v10.xls!A_ but when I click into the field and try to close the graph, I get a "formula you typed contains an error" message. Any ideas what I should troubleshoot? Thanks, Keith |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Copied hyperlink not working | Excel Worksheet Functions | |||
Copied worksheet not working | Excel Discussion (Misc queries) | |||
Are there better GRAPHS within EXCEL or Add-on graphs? | Charts and Charting in Excel | |||
Automatic Graphs/ Dynamic Graphs | Charts and Charting in Excel | |||
Line Graphs and Bar Graphs | Excel Discussion (Misc queries) |