Help

[xgary.wilsonx]

Please help - very new to posting for help so please be gentle

I wish to have a macro button that will create a graph from a table of data, however i want to be able to specify which columns and rows of data the macro will use to create it. I was going to record a macro (basic i know) that will copy an existing graph (for format etc) then amend the source data, legend etc. However i have no idea how to get the macro to only select the columns i want and all the populated rows below it.

Is this possible?

and if so how can i do this?

example of table

All Graph2 Graph1 Graph2 Graph1

Name Basic Word Excel Access SQL
Mike 4 4 5 6 2
Gary 6 5 3 2 2
Peter 5 3 2 1 5
David 5 5 5 4 4

Where graph one will be created showing column chart for only excel and SQL.

Please help, many thanks in advance



Gary

 

[gardnertoo]

I did the "record macro" method, and here's the code lines for adding a series from a specific range of cells, J22:J26 in this case, with G23:G26 holding the employee names:

    ActiveChart.SeriesCollection.NewSeries
    ActiveChart.SeriesCollection(1).XValues = "=Sheet1!R23C7:R26C7"
    ActiveChart.SeriesCollection(1).Values = "=Sheet1!R23C10:R26C10"
    ActiveChart.SeriesCollection(1).Name = "=Sheet1!R22C10"