You're welcome Don and glad this is something for you to work with.

I highlighted A1:G10

Insert >> Charts >> 2D Line

Once the chart is created, I right clicked on the Weight series >> Format Data Series >> Series Options >> Plot Series On >> Secondary Axis

Now I just formatted all the series that I don't want as a line into something else

For the weight series >> right click >> Change Series Chart Type >> Clustered Column

It would be worth now doing a search for Dynamic Ranges

With using dynamic ranges you could now keep all of your data on one tab and then cycle all the data through one chart.

Let me know if you require anymore help