View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.charting
ker_01 ker_01 is offline
external usenet poster
 
Posts: 395
Default Dynamic charts in 2007

I've used dynamic charts in 2003 for several years. I now have an internal
customer who has moved to 2007 and would like some dynamic charts. I obtained
access to a 2007 machine, loaded his current workbook, and noted that the
interface is very different.

I am accustomed to right-clicking a chart, selecting 'source data', then
going into the series tab to put the named range in.

In this workbook, I right click and the closest option I have is 'select
data' which brings up a 'select data source' userform that is set to a full
range (multiple series) of data.

Since this is my first exploration of Excel2007, I don't know if this is an
issue with my not knowing where to look, the setup of this particular
file/graphs, or something about 2007 overall.

I did google and revisit all the sites I knew about that had info on dynamic
charting, but they all seem to point toward the individual series like what
I'm used to in 2003.

Can anyone give me a nudge in the right direction?

Thanks!
Keith