-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
chart sources
-
E
VBA to set the Source Data of a Chart as a Variable
Hi, I was wondering if it is possible to set the source data in a chart as a variable? Or even just display it in a msgbox? I tried to do MsgBox cht.SetSourceData.Source but that obviously didn't work as I believe that is how you set the source... Anyone have any ideas for me? Thanks, Eoin- eoinymc
- Thread
- chart sources source data of a chart vba
- Replies: 0
- Forum: Excel Questions
-
R
Selection -> Range -> Chart
Hey guys, since I am a real loser at using range, I gotta ask you the following. I want to create a chart from an area of data. Please see the following code and tell me what I am doing wrong. Many thanks! ' variables Dim AAAA as Worksheet Dim BBBB as Range 'requested range...- ReeveCZE
- Thread
- chart sources range cell variables
- Replies: 1
- Forum: Excel Questions
-
L
Referencing Variable Worksheet names in chart source data
Forgive me if I am wrong but I cannot find the answer to my question on other threads so I am going to ask. Background Info: Using - Excel 2007 through windows xp I am accessing a SQL server to retrieve a table of data. I am then using a macro to open a userform in which the user inputs data...- lankybones
- Thread
- chart sources charts source data variable worksheet name variables
- Replies: 4
- Forum: Excel Questions
