1. T

    How to Refer to Contiguous ListColumn Ranges by Index

    Hey all, I'm writing a macro to set the source data of a chart to several contiguous table columns but I'm stumped at the syntax. The table column headers can change so I'm trying to refer to their index numbers instead. 1 Dim Table1 as ListObject: Set Table1 = Sheet1.ListObjects(1) 2 Dim...
  2. M

    Charting with VBA - wanting to use .End(xlDown) but getting method failure

    Hi All, I've read more web posts and tried more things that I can shake a stick at... none seem to work. I've hard coded the name of the data sheet that I'm using for now... but will revert to using the parameter that I pass to the subroutine later. Sub CreateGraphs(ProjectToGraph As...
  3. C

    .SetSourceData Invalid Parameter error

    Hi, I'm working on code that loops through different user IDs and for each user ID, the code updates a set of charts based on that user's unique data. The code below activates a Chart object (hpu), sets the source data to a Range object (hpu_range), plots the data by rows instead of columns...
  4. R

    Setsourcedata from a temporary worksheet (VB6/not VBA)

    I have placed 2 sets of data on worksheet(3), and successfully created a column chart on worksheet(1) & another on worksheet(2). I then want to save the spreadsheet, without worksheet(3). If I delete or clear the worksheet before doing the SaveAs, the charts are garbage. Charts were created...
  5. P

    Excel 2010 Chart SetSourceData 1004 error

    Hello, I have a problem with an Excel application that was written in my company using Office 2003. It has always worked properly in Office 2003 but when I run it in Office 2010 I get an error message after executing the SetSourceData to apply a Range taken from a group of cells in the...
  6. N

    Set Source Data for Chart on different sheet

    Hi there, I am very new to VBA. I have written the following code Sub Series1() Sheets("Charts").Activate ActiveSheet.ChartObjects("Chart 3").Activate ActiveChart.PlotArea.Select ActiveChart.SetSourceData Source:=Sheets("Raw Data").Range("Y16:Y266") End Sub When I had the...
  7. R

    Updating Source Data in powerpoint charts

    Hello forum, I have charts in powerpoint which are linked to an excel workbook. When trying to change the source data using .SetSourceData, nothing happens. It works if I manually change the data range first, and then re run the code, but I may aswell set the source data manually each time...
  8. R

    Set Source Range of charts in powerpoint

    Hello forum, I have a macro written in excel vba that updates the source links of charts in powerpoint to another excel file. When running this, the source data uses the exact same range as in the previous spreadsheet (as expected). Old Workbook <tbody> A B C 1 Buyers Sellers 2 UK 23 12...
  9. H

    C# : Chart.SetSourceData -> Exception

    Hallo there, I would appreciate help on two questions : 1) what could be the reason for this line to throw an exception : range = worksheet.get_Range("A3", "B4"); myChart.SetSourceData(range.ToString(), PowerPoint.XlRowCol.xlColumns); I also tried If I do it this way...
  10. T

    Updating chart sourcedata range in VBA

    I am relatively new to VBA and I am having trouble updating the sourecdata for a chart in VBA. Recording a macro for it yeilded: Sheets("Rating Chart").Select ActiveSheet.ChartObjects("Chart 1").Activate ActiveChart.ChartArea.Select ActiveChart.SetSourceData...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back