scatter graph

  1. B

    XY Scatter not showing correct percentage values

    Why are all of my menu items showing on my scatter graph twice, once at 100% and again as 200%? Why is the x-axis not showing the popularity values (C1:C12)?
  2. V

    Adapting VBA script for multiple series

    Hello, Should be an easy one. Struggling to adapt this macro for multiple vba scripts: https://support.microsoft.com/en-gb/help/213750/how-to-use-a-macro-to-add-labels-to-data-points-in-an-xy-scatter-chart Any ideas and what data form it should be in? Cheers in advance!
  3. V

    Scatter Graph Markers - VBA

    Hello All, Been struggling trying to adapt my working VBA to a user friendly one. I have data in the form: | X. |. Y. | A. |. 1. |. 2. | B. |. 2. |. 3. | C. |. 3. |. 3. | With A, B, and C with different conditional formatting...
  4. K

    how to Coloring the data points in a scatter plot

    hello again , i have some number data set (below), i would like to plot with different color, say, 1 ,2, 3, 4, 5, 6= red; 7, 8, 9, 10, 11,12 =blue, 13, 14, 15, 16, 17,18=black; .....5=green..... <tbody> 3 8 15 16 17 38 35 1 6 19 26 28 </tbody> ........ and...
  5. E

    Scatter Chart & Bar Chart

    Hi, I want to amalgamate a scatter chart and a bar chart. I have the following data <tbody> 09:00 09:15 10:00 10:35 11:00 London 5 4 Total 10 20 15 Sold 8 17 13 </tbody> So basically, I want to see the following two graphs amalgamated...pictures attached... (View image: Total...
  6. E

    Conditional Formatting of a scatter graph

    Hi All, Thanks for checking this post, and thank you even more if you can help! I've had a search and found nothing the same as what i need to know, apologies if this has already been asked. I'm seriously stuck and in need of help, I need to plot a heatmap of data based on geographical...
  7. A

    Producing charts from data

    Hi guys, I'm working on a project where I have to analyse reviews, gain feedback reviews and produce charts. Let me show you some example data... <colgroup><col width="64" span="26" style="width:48pt"> </colgroup><tbody> reviews Jan-13 Feb-13 Mar-13 Apr-13 May-13 Jun-13...
  8. T

    Start scatter line data later in the graph

    As title suggests... I am reporting on the amount of certificates issued over a period of time. Basically the government stopped released data on the amount of one type of certificate being issued during this period and started releasing data on another type. I am having trouble displaying this...
  9. J

    Customizing Colours in Scatter Graph

    Hello, I'm having some difficulties trying to customize the colours of separate plots in a scatter graph. I have 6 different data sets to put on one graph and am trying to make the symbols for the data points as follows: - 1 set solid green circles - 1 set open green circles - 1 set solid blue...
  10. P

    How to Group Data in 3D Dimensional Scatter/Line Graph

    Hi, Kindly put me through on how to plot and group Data in 3D Dimensional Scatter/Line Graph in MS Excel. Thanks
  11. M

    Scatter Graph Question

    <?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" /><o:p> </o:p>I need to a scatter graph in a stop light format in the background (red, yellow, green). In addition, when I use the chart function (to create the scatter graph), I have been unsuccessful in being able to...

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