Define a variable for dynamic chart

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a excel file wich I have modified with a number of userforms, macros
and so on. One of the macros make a chart wich the user can page through
several columns. One by one. I want the user to be able to save the file
witout having to change the macro.

I know how to define the open workbook as a variable, but I am not sure how
to use a variable in this macro?

ActiveChart.SeriesCollection.NewSeries
ActiveChart.SeriesCollection(1).XValues = "='Log_1.xls'!XValues"
ActiveChart.SeriesCollection(1).Values = "='Log_1.xls'!YValues"
ActiveChart.SeriesCollection(1).Name = "='Log_1.xls'!Name"

Can anyone help me?
 
Maybe I didn't explain well enough. I want to exchange the
"='Log_1.xls'!XValues" with something like "=Variable!XValues". This is to be
able to save the file with another name.

BTW:

VH skrev:
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Bubble Chart 1
Adding Chart problem 0
adding a data series to a chart with variable inputs. 2
Floating Chart? 1
Excel 2007 Charting macro 1
Chart Control 11
I want VB to select data automatically to the end of the row 4
chart range to include variables - Macro 1

Back
Top