Charts based on dynamic ranges in Excel Services 2010

Hey folks, been asked about this a few times already, so thought I would post – if you are using any of the betas, you will notice that your charts based on dynamic ranges that used to work in 2007 no longer work. This has been fixed and will be available in the RTM bits.

If you have any questions, feel free to comment. If you have sample workbooks that use charts based on dynamic ranges you can share, please send them to me, I will try to find some time to make sure they work.

Comments

• Anonymous
  February 02, 2010
  The comment has been removed

• Anonymous
  February 02, 2010
  Did you try hiding the row containing the filter? I am not connected to corp, so I cannot test it on a live Excel server. Let me know if it does not work for you.

• Anonymous
  February 19, 2010
  Thanks for the good news.  There are so many scenarios that use dynamic named range data series based charts all over the place that we even started to work on an OOXML workaround based on your previous blog post.

• Anonymous
  February 19, 2010
  Thanks for finding it. :)