I’m looking for the number for a basic scatter plot graph for excel.
I have to make some graphs from a form, I have found the corrisponding numbers for a stacked graph and an area graph, but I need the number for a scatter plot graph.
Does anyone know it?
Subject: RE: Scatter Plot
If you don’t get an answer here, perhaps a MS forum would be a better place to ask.
Subject: Here is how I find them…
Go to Excel, create a graph. Then Tools, Macro Record. Switch Graph Type to Scattered. Stop recording macro. Then Tools, Macro, Edit and edit in the VB editor. Debug, Step Into. Hover w/ mouse over variable for ScatterPlot. The Numeric value will be displayed.
Subject: RE: Here is how I find them…
Thank you very much Bill. That worked great.
For anyone who is wondering, the number of a XY scatter plot is -4169. I would never have guessed that.