Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.charting
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
  #2   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 395
Default Dynamic charts in 2007

Ok, more searching and more playing, and I'm a lot closer than I was. Now
I've hit something that appears to be a bug(?)

From my user's data table, I created 7 named ranges. The first is the real
dynamic named range [=OFFSET(Graphs!$B$14,0,0,1,COUNT(Graphs!$B$14:$M$1 4))]
and all of the rest are offsets from that range[ e.g., =OFFSET(NCR, 1,0)].
All have the scope 'workbook'.

So when I enter new data into the table, all of the series show their new
entries *except* my main named range, NCR. That one just stays blank on the
graph. The named range is autoexpanding to include the new months, they just
aren't showing on the graph. Any entries in the other named ranges do show as
expected.

Any ideas why my primary range isn't updating?

Thanks!
Keith


"ker_01" wrote:

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

  #3   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 6,582
Default Dynamic charts in 2007

Excel 2007 has "clarified" things by combining the series and data range
tabs. To edit the series information, you select the series in the list
below the data range and click the Edit button.

Of course, I've always found it easier to edit the series formula, replacing
the cell address with the name (while keeping the reference to the worksheet
name). This works the same in all modern versions of Excel. The only
difference is that 2007 chokes on names that begin with the keyword "chart",
so instead of using names like "chartdate" and "chartvalue" use "chtdate"
and "chtvalue".

- Jon
-------
Jon Peltier, Peltier Technical Services, Inc.
http://PeltierTech.com/WordPress/

Advanced Excel Conference - June 17-18 2009 - Charting and Programming
http://peltiertech.com/Training/2009...00906ACNJ.html
_______


"ker_01" wrote in message
...
Ok, more searching and more playing, and I'm a lot closer than I was. Now
I've hit something that appears to be a bug(?)

From my user's data table, I created 7 named ranges. The first is the real
dynamic named range
[=OFFSET(Graphs!$B$14,0,0,1,COUNT(Graphs!$B$14:$M$1 4))]
and all of the rest are offsets from that range[ e.g., =OFFSET(NCR, 1,0)].
All have the scope 'workbook'.

So when I enter new data into the table, all of the series show their new
entries *except* my main named range, NCR. That one just stays blank on
the
graph. The named range is autoexpanding to include the new months, they
just
aren't showing on the graph. Any entries in the other named ranges do show
as
expected.

Any ideas why my primary range isn't updating?

Thanks!
Keith


"ker_01" wrote:

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



Reply
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
Dynamic Charts [email protected] Excel Discussion (Misc queries) 1 September 20th 07 04:22 AM
Using named ranges in dynamic charts (excel 2007) fruitticher Excel Worksheet Functions 8 September 19th 07 04:56 PM
Dynamic Charts Clark Charts and Charting in Excel 0 August 24th 07 09:16 PM
Make dynamic charts more dynamic Milo Charts and Charting in Excel 1 April 12th 06 09:01 AM
dynamic charts Dave Breitenbach Charts and Charting in Excel 5 July 1st 05 05:49 AM


All times are GMT +1. The time now is 12:17 PM.

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

About Us

"It's about Microsoft Excel"