Width:=m圜htRange.Width, Height:=m圜htRange. Left:=m圜htRange.Left, Top:=m圜htRange.Top, _ A quick note here: in creating scatter plots, a. Excel will automatically create a scatter plot for you in the same sheet as your data, using the first column of your dataset as the horizontal (X) axis, and the second column as your vertical (Y) axis. Prompt:="Select a range containing the chart data.", _ Select Scatter from the options in the Recommended Charts section of your ribbon. Then click Select Data from the dropdown menu: In the new window that appears, click Add under the Legend Entries box. Set myDataRange = Application.InputBox( _ The XAXIS, X2AXIS, YAXIS, and Y2AXIS statements specify options for the plot axes. Next, right click anywhere on the scatter plot. Prompt:="Select a range where the chart should appear.", _
#4 data set xy scatter plot excel series#
This macro creates one Series perfectly, but if I want to add prompts for the user to define the next Series and add it to the Scatter Plot, how would I do that? Thanks for any help you can give, if this doesn't make sense or you can think of a better way to do this please let me know! To see what the chart will look like, click on the button that says Press and Hold to View Sample. This is a task I do at least 10 times a day and requires anywhere from 2 to 8 series in the Scatter Plot, and data for all the Series' can be spread across one sheet or on multiple tabs, so I'd like to have the prompt boxes keep asking for the next Series to add until the user clicks Cancel. Step 7 - Select XY (Scatter) as the chart type.
I'm trying to make a macro that creates one Scatter Plot with many Series.
0 kommentar(er)
