robertpaulson12345
New Member
- Joined
- Jun 30, 2021
- Messages
- 2
- Office Version
- 365
- Platform
- Windows
Hello,
I'm fairly new to VBA and I'm trying to format a chart with multiple columns of data automatically. How could I go about positioning specifically the series name of the data to the maximum data for each series of the chart? I've been trying ActiveChart.FullSeriesCollection(counter).DataLabels.Position = findMax but that's not working. I know ActiveChart.FullSeriesCollection(counter).DataLabels.ShowSeriesName shows the name, but I want to manipulate it.
Thanks!
I'm fairly new to VBA and I'm trying to format a chart with multiple columns of data automatically. How could I go about positioning specifically the series name of the data to the maximum data for each series of the chart? I've been trying ActiveChart.FullSeriesCollection(counter).DataLabels.Position = findMax but that's not working. I know ActiveChart.FullSeriesCollection(counter).DataLabels.ShowSeriesName shows the name, but I want to manipulate it.
Thanks!