ExcelBanter - Multiple Charts

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - Multiple Charts (https://www.excelbanter.com/excel-programming/375519-multiple-charts.html)

Hi,

I have been given an assignemnt to create 5 charts that will print on E
size paper that are suppose to appear next to each other. Each chart
takes 14 rows of data that are in the sheet.

I can create one chart but am having difficulty coding the concepts of
making them appear next to each other.

can anyone help? I very much appreciate it.

Chart1.Left = 0
Chart1.Top = 0
Chart2.Left = Chart1.Left + Chart1.Width
Chart2.Top = 0
Chart3.Left = Chart2.Left + Chart2.Width
Chart3.Top = 0

Got the idea?
--
Charles Chickering

"A good example is twice the value of good advice."

"scorpion53061" wrote:

Hi,

I have been given an assignemnt to create 5 charts that will print on E
size paper that are suppose to appear next to each other. Each chart
takes 14 rows of data that are in the sheet.

I can create one chart but am having difficulty coding the concepts of
making them appear next to each other.

can anyone help? I very much appreciate it.