To add points manually to your chart first select the chart and then from the Chart menu select Add Data.
This will allow you add data as either a new series or new points.
How can one add data points manually to create a chart? I can add the sheet and create the chart but I can't figure out how to create the array of data points and get them plotted.
My data sets overlap so many points actually have multiple shapes and labels overlapping so many are illegible and difficult to work with. I'm considering just putting a single point wherever one should be and creating a single label listing all the data sets it applies to.
Sorry, I should have been more specific - I meant add points manually in a VBA subroutine.
The data I want to graph is based on but not directly the data in my spreadsheet. My plan was to analyze the data, then create the array of points and the SeriesCollection in VBA. However, I can't figure out or find how to create the points or add them.
This routine will add datapoints and a data series to an existing chart.
Dim rngNewPoints As Range
Set rngNewPoints = Range("A1:A4")
' new points
' new series
.SeriesCollection(.SeriesCollection.Count).Values = rngNewPoints
There are currently 1 users browsing this thread. (0 members and 1 guests)