Conditional Formatting of a scatter graph
Results 1 to 3 of 3

Thread: Conditional Formatting of a scatter graph
Thanks Thanks: 0 Likes Likes: 0

  1. #1
    New Member
    Join Date
    Sep 2014
    Posts
    16
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default 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 location, this needs to be done in Excel only, as it is to be a shared document.

    I have my location coordinates set up to graph out the XY to the right scale perfectly, however, i need to add another variable into the mix, quantity.
    I would like to format the markers to change colour from a scale of highest to lowest, failing that then the alternative is to change the marker size.

    I have seen a 3D scatter graph, however this is unsuitable as it will hide a significant amount of data as the columns grow.

    Any help with this would be massively appreciated.

  2. #2
    Board Regular ParamRay's Avatar
    Join Date
    Aug 2014
    Location
    England, UK
    Posts
    1,192
    Post Thanks / Like
    Mentioned
    1 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Conditional Formatting of a scatter graph

    .
    .

    Perhaps a bubble chart might a suitable for this problem. It is like a scatter chart, but you can vary the size and colour of the markers (bubbles) point by point...
    Windows 10, Excel 365

  3. #3
    New Member
    Join Date
    Sep 2014
    Posts
    16
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Conditional Formatting of a scatter graph

    Thanks for the suggestion, however it would appear that I have too much data for a bubble chart.
    any other suggestions?

Some videos you may like

User Tag List

Tags for this Thread

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •