#1
|
|||
|
|||
Chart formatting VBA
I don't want to save as a chart template but instead want to assign a macro to something that once a chart is highlighted, will remove the border line and set a shadow.
I've recorded the macro and the VBA reads as below, but obviously references 'Chart 1'. Could you advise how I can amend the macro so that it refers to the chart that I've clicked in to focus please? ie, click to focus on a chart and then I run the macro? Thanks Sub Prep_Chart() ' ' Prep_Chart Macro ' ' ActiveSheet.ChartObjects("Chart 1").Activate ActiveSheet.Shapes("Chart 1").Line.Visible = msoFalse ActiveSheet.Shapes("Chart 1").Shadow.Type = msoShadow21 End Sub |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Formatting an Org. Chart (SmartArt) to fit in a page | DSS90 | PowerPoint | 1 | 10-08-2014 07:12 PM |
Formatting an Org. Chart (SmartArt) to fit in a page | DSS90 | Drawing and Graphics | 3 | 10-08-2014 08:15 AM |
MS Project 2013 Reports: ACWP in Timephased Line Chart does not match ACWP in Column Chart or Table | billcary | Project | 3 | 09-22-2014 07:10 AM |
Gantt chart bar formatting summ vs recurr task | Intruder | Project | 1 | 02-02-2014 08:19 AM |
Converting manual chart to bar chart? | aligahk06 | Excel | 0 | 07-03-2010 12:23 PM |