xy scatterplot

Dear All, I am struggling trying to set up a code in VBA to create a chart in the active w/s. This chart should be a scatter line with no markers. The x values are constant for all the series (column A from A19 - the end will be dynamic). The y values will vary. The number of series will also...

Hi All I found the following code on the MS Support site which adds custom data labels to scatter graphs. It working, however when I filter the data and then run the macro I get an 'Invalid Parameter' error. Any idea on how to modify it so it says to count only the visible cells? Thanks Sub...

I'm working on a macro that will format a chart so that it will look the same as all of my other charts. Getting the code set up for my XY Scatter charts has been causing problems. I've been recording keystrokes and then building the code from there. The issue I'm working on right now is this...

First time poster... I have a XY Scatter Chart acting as a project timeline and want to allow individuals to zoom in on sections of the chart (Manual mode) and then switch back to the Excel auto-scale (Auto mode). I've added a tick box that when ticked it should auto-scale the chart and if...

Hi All, I'd like to add a message box to the following macro. Sub FormatDataPoints() Dim i As Long With ActiveSheet.ChartObjects("Chart 1").Chart For i = 1 To 10 With .SeriesCollection(i) .MarkerStyle = 2 .MarkerSize = 7...

I have the following vba code, which should go through series 1-30 in chart 1 and format them according to the code. But the code tells me that there's an invalid parameter with the line "With .SeriesCollection(i)". Does anyone know what's going on? I'm at a loss. I thought this should work...

I have an xy scatterplot chart with multiple series. I'm trying to write a macro that will add error bars to the series of my choice. I wrote this, but I can't figure out the errors with the code. I would like the error bars to have custom values of 50, so that they cover the width and height of...