Will a dynamic chart work if I have info going horizontal instead of vertically? Thank you! Larisa
L Larisa May 8, 2008 #1 Will a dynamic chart work if I have info going horizontal instead of vertically? Thank you! Larisa
A Andy Pope May 8, 2008 #2 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
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
L Larisa May 8, 2008 #3 Thanks Andy I'll give that a try! Andy Pope said: 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 Click to expand...
Thanks Andy I'll give that a try! Andy Pope said: 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 Click to expand...