-
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
Watch MrExcel Video
This Week's Hot Topics
-
Excel VBA Parse Column A into multiple columns help but with conditions
- Started by BalloutMoe
- Replies: 59
Hello, I have a TXT file that gets imported in excel and it always ends up in column A. I am trying to split the data up however. The middle... -
Data with Different score
- Started by sksanjeev786
- Replies: 30
Hi Team, I have a Wave 2 and Wave 1 data and need different only if we have any letter in Column A and B in Column D for example i have kept data... -
Looping a macro through all visible sheets?
- Started by GlennJ
- Replies: 29
I have a macro that does exactly what I need. I just need it to do the same thing to all sheets. Any help would be appreciated. [CODE=vba] Sub... -
Loop through Column, looking for an array of values, If NOT found, delete entire row
- Started by blbat
- Replies: 29
So I tried to modify some good code from Joe4, but ran into some walls. I'm trying to modify his working loop to cycle through Column "D", find... -
VBA to extract values starting with specific character
- Started by sncb
- Replies: 21
Hi all, I paste two cells of data into A1 and B1 with different formats and spacing like below and I need to extract only those values that start... -
macro/vba fix for not a blank, blank in Go To Special
- Started by LorettaAlsop
- Replies: 20
I am writing vba code (thru using macros) to format a ws. In a portion of the formatting I identify the blank cells and replace them with the cell...
