LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 55
Default Copied graphs not working

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Copied hyperlink not working jinx Excel Worksheet Functions 4 April 30th 07 04:04 PM
Copied worksheet not working [email protected] Excel Discussion (Misc queries) 0 June 15th 06 08:01 PM
Are there better GRAPHS within EXCEL or Add-on graphs? Deb Charts and Charting in Excel 1 February 1st 06 01:19 PM
Automatic Graphs/ Dynamic Graphs DanielWalters6 Charts and Charting in Excel 1 January 24th 06 09:29 PM
Line Graphs and Bar Graphs Christopher Anderson Excel Discussion (Misc queries) 1 December 3rd 04 06:16 PM


All times are GMT +1. The time now is 04:37 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"