source data of a chart

Hello everyone! I'm fairly new to Excel, and completely self-taught, so please bear with me. :) I have an Excel table with formulas in it, and I'd like the source data to come up in a new sheet if I click in the cells (much like with a pivot table). I have seen this working in a similar table...

I'm doing a horizontal range but having issues. Here's my example code: resSurvey = Range("C3").End(xlToRight).Column Sheets("dash").ChartObjects("Chart 12").Activate ActiveChart.SetSourceData Source:=Range("res_surveys!$C$35:$" & resSurvey & "$35") This doesn't work because...

Hello, I currently have a spreadsheet that automatically calculates data and populates a 12 month chart. However, I do not want to delete the previous months data that was generated, but I am having trouble selecting a dynamic range with static legend data. I want all of the data from previous...

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

Hi, I am wondering if anyone here knows if there is any way possible to recreate the 'Double Click to Source Data' event on a pivot table. For instance, I have created a few tables using sumif and countif etc etc, I would like to recreate the 'Double Click to Source Data' event within this...

I was wondering if anyone knows how to make fill color become data marker color within a single series of data. I could make 4 individual series but I was hoping someone might know how to get the program to do this automatically. T

Hi, I am trying to change a chart data source to some values of variable that have been calculated in VBA itself, but I am failing to do so :( The variable names that I have calculated are a, b, c, and ot I tried doing this: 'change the chart numbers Sheets("Sheet1").ChartObjects("Chart...