chart sources

  1. 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
  2. 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...
  3. 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...

Some videos you may like

This Week's Hot Topics

  • Sort code advice please
    Hi, I have the code below which im trying to edit but getting a little stuck. This was the original code which worked fine,columns A-F would sort...
  • SUMPRODUCT with nested If statement
    Hi everyone, Hope you're all well. I'm hoping someone will be able to point me in the right direction with a problem I'm having with a SUMPRODUCT...
  • VBA - simple sort is killing me!
    Hello all! This should be so easy, but not for me, apparently! I have a table of data that can be of varying lengths and widths. My current macro...
  • Compare Two Lists
    I have two Lists and I need to be able to Identify differences between them. List 100 comes from a workbook - the other is downloaded form the...
  • Formula that deducts points for each code I input.
    I am trying to create a formula that will have each student in my class start at 100 points and then for each code that I enter (PP for Poor...
  • Conditional formatting formula required for day of week and a value
    Hi, I have a really simple spreadsheet where column A is the date, column B is the activity total shown as a number and column C states the day of...
Top