Solved

excel graph

Posted on 2014-07-28
4
424 Views
Last Modified: 2014-08-05
I want to create a scatter diagram graph of results in excel.  But as a background on the graph I want to show regions which the results fall into.  The same background would be shown on the graph if the results are updated. Its like a template graph.  Can this be done in Excel, and if so, how?  If not, do you have a good suggestion on another way to do this.

As an example, have attached a hand-drawn graph of what it would look like for a graph of risk results, in which lines and wording are added to show which risks are 'high', 'medium' or 'low'.  6 points have been plotted.  The number and value of the points may change, but the boundaries should stay the same.
Risk-Graph001.jpg
0
Comment
Question by:gh_user
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
4 Comments
 
LVL 51

Accepted Solution

by:
Rgonzo1971 earned 500 total points
ID: 40225999
Hi,

You can do it by combining XY Chart and stacked column with no gap

Regards
EE20140729.xlsx
0
 

Author Comment

by:gh_user
ID: 40226019
Thats great Rgonzo1971
0
 
LVL 1

Expert Comment

by:Jon_Peltier
ID: 40242874
I'm sure you could also adapt the technique in my tutorial Shaded Quadrant Background for Excel XY Scatter Chart
0
 

Author Comment

by:gh_user
ID: 40242924
Thanks Jon
Thats a great tutorial
0

Featured Post

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article will guide you to convert a grid from a picture into Excel format using Microsoft OneNote and no other 3rd party application.
Do you use a spreadsheet like Microsoft's Excel?  Have you ever wanted to link out to a non excel file on your computer or network drive?  This is the way I found to do it!
In addition to being a great web-based presentation tool, Prezi also makes it easy to save your presentation as a PDF to share with others as well. Learn how in this tutorial. Select the share icon from the top menu in your Prezi editor: Select "D…
I designed this idea while studying technology in the classroom.  This is a semester long project.  Students are asked to take photographs on a specific topic which they find meaningful, it can be a place or situation such as travel or homelessness.…

738 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question