#1   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 5
Default Dynamic Charts

Will a dynamic chart work if I have info going horizontal instead of
vertically?

Thank you!
Larisa

  #2   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 2,489
Default Dynamic Charts

Hi,

Depends on what method you have used to make your chart data dynamic.
I don't think charts based on lists or tables will.

But those based on Named Ranges will as long as your amend the formula
to have dynamic column offsets and lengths rather than the normal rows.

Cheers
Andy

Larisa wrote:
Will a dynamic chart work if I have info going horizontal instead of
vertically?

Thank you!
Larisa


--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
  #3   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 5
Default Dynamic Charts

Thanks Andy I'll give that a try!

"Andy Pope" wrote:

Hi,

Depends on what method you have used to make your chart data dynamic.
I don't think charts based on lists or tables will.

But those based on Named Ranges will as long as your amend the formula
to have dynamic column offsets and lengths rather than the normal rows.

Cheers
Andy

Larisa wrote:
Will a dynamic chart work if I have info going horizontal instead of
vertically?

Thank you!
Larisa


--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info

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
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 Kirk Charts and Charting in Excel 2 March 10th 06 09:32 PM
Dynamic Charts vrk1 Charts and Charting in Excel 4 September 1st 05 03:16 PM


All times are GMT +1. The time now is 09:01 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"