Creating a chart using data from two columns

Question

I have two columns with data. One column for Y-axis, another for X-axis. How can I create a chart using this data? Range is different (from 10 cells to 3000).

Thanks a lot!

each column has a different row count, or at different times both of the columns can have different row counts but both columns will always have the same row count as each other? Perhaps Dynamic Named Ranges can help? — Scott Holtzman
– Scott Holtzman, Commented Dec 3, 2015 at 18:04

Luboš Suk · Accepted Answer · 2015-12-03 18:09:23Z

1

For X and Y axis you have different property .values and .xvalues see more here https://msdn.microsoft.com/en-us/library/office/ff197014.aspx and https://msdn.microsoft.com/en-us/library/office/ff821866.aspx. There is nothing more to tell, but if you dont understand something try to ask.

answered Dec 3, 2015 at 18:09

Luboš Suk

1,57614 silver badges41 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

levshkatov Over a year ago

Thanks for help! I have a problem with a range. It differs but it depends on numbShag. I tried to use mainChart.SeriesCollection(1).Values = Worksheets(1).Range("F1:F" & numbShag) but I have an 1004 error.

levshkatov Over a year ago

Solved. Forgot about mainChart.SeriesCollection.NewSeries

Collectives™ on Stack Overflow

Creating a chart using data from two columns

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related