Dynamic Charts
 

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

Thank you!
Larisa

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

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