scatter plot chart

  1. P

    Plotting a dynamic amount of series on a chart

    Hi, Long time lurker first time question poster here :) I'm trying to plot a variable amount of series on a chart. I've created a dummy environment with data for my issue, however in the actual issues case, the data table in B29:R47 is filtered from a master on another sheet which I cannot...
  2. W

    Custom Data Labels for Scatter Plot

    I have data in a table such as this example, tracking recentcompetitions. Most data is in pivot table, but then cells are linked to astandard table. I have conditional formatting to highlight the status of the competition based on Active/Won/Lost (No color/Green/Red). This is then linked to an...
  3. C

    Landing a number in a scatter plot

    Hi There, I'm hoping to find out how to populate a number from a list (1,2,3,4...) inside a marker of a scatter plot. For example, the marker might show as a red square on the graph, and inside that square, I'd like to be able to identify the data point with a number. Please help! Thank you...
  4. C

    Creating a Scatter Plot with VBA

    Hi, I am trying to create a scatter plot but have run into some issues. I have 2 columns - 1 I want for the y axis, and 1 for the x axis. However, my code makes the chart so that the x axis is how many rows of data there are (0 to 6) and then plots 2 lines with data on the y axis. How do I fix...
  5. B

    Excel 2007 scatter plot chart - How to load data efficiently

    Is there an efficient way to load 30 data series having 6 (x,y) paired data points? It seems you have to highlight 3 ranges for each series (legend, x value, y value) x 30 in series = 90 highlights. Am I missing something here? :banghead:

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top