If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Linking a Bar Chart
I have a bar chart linked into my active worksheet. The
linked bar chart is based upon data that is using a named range - specifically using the offset formula function. I used this formula to automatically update the chart based upon the new month's data. However, my active worksheet will not update any changes to the linked bar chart. When I try to update it manually I get the message that says: "The name you specified is defined as something other than a rectangular cell reference". Anyone ever see this? Any thoughts on how to work around this? |
#2
|
|||
|
|||
Linking a Bar Chart
Brian -
What is the Refers To formula for your named range? And what does the series formula look like? - Jon ------- Jon Peltier, Microsoft Excel MVP http://www.geocities.com/jonpeltier/Excel/index.html _______ briank wrote: I have a bar chart linked into my active worksheet. The linked bar chart is based upon data that is using a named range - specifically using the offset formula function. I used this formula to automatically update the chart based upon the new month's data. However, my active worksheet will not update any changes to the linked bar chart. When I try to update it manually I get the message that says: "The name you specified is defined as something other than a rectangular cell reference". Anyone ever see this? Any thoughts on how to work around this? |
Thread Tools | |
Display Modes | |
|
|