Adding additional source data to a chart

[Mavis Cruet]

This is the first time I'm using Macros in Excel and I'm having trouble trying to add additional source data to a chart. I created a macro using the record macro tool; however it only generates a new series on the chart. The Name, X Value and Y Value fields are completely empty. How do I change the macro to populate them?

Thanks

Please Login or Register  to view this content.

[mrice]

Try

Please Login or Register  to view this content.

and then set the values in a similar way to those in the code that you recorded.

[Mavis Cruet]

Thanks. I tried that and it still creates a new series without data. A run-time error occurs, when going into the debug option the second line in code is highlighted. I'm very new to all this and really appreciate you helping me out :-)

Code:
sub snb()
ActiveChart.SeriesCollection(5).XValues = "=BER!R26C2:R33C2
end sub

[mrice]

Try this.

Please Login or Register  to view this content.

[Mavis Cruet]

That also still doesnt work :-( this time the debugger higlights the .values line. I'm starting to think it might be easier to keep adding measurements manualy :-(

[Andy Pope]

It would probably help to post example file explain further what the code should do.

[Mavis Cruet]

I've (hopefully) attatched a simpler version of what I'm attempting to do.

Basically I have three sets of results for one mission. In order to easily compare new missions to older ones I want to plot the data onto a graph. However I currently have over 20 old missions with new ones coming every six months or so. And as I'm not the only person who will be using this document in the future I wanted to automate all the graphing functions. So in the future they will simply copy the data input tabel then implement a macro for it to add the data to the chart.

I thought I'd try to get a simple macro to just plot data before I attempted to work out how to make it shift down the sheet as new data sets are added.

Thanks for trying to help me solve this problem :-)

[Andy Pope]

No attachment. Is it too big?

[Mavis Cruet]

I dont think so I completly striped it down its only 36.5KB. It says its attatched in the Attatch files section.

[Andy Pope]

This will prompt the use for a test name.
It will use series 4 to 6, creating series if required.

Please Login or Register  to view this content.

[Mavis Cruet]

Thank you so much its perfect! :-D