[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
?
Solved

I have a line graph with data in and need to add a shaded section in a range please can anyone help?

Posted on 2011-03-23
5
Medium Priority
?
246 Views
Last Modified: 2012-05-11
data1  10%   11%  12%   13%
data2   8%     9%    20%   3%
data3   2%      3%    2%     4%

range on graph need to show between 5% and 7%
0
Comment
Question by:LeiaO
  • 2
4 Comments
 
LVL 43

Accepted Solution

by:
Saqib Husain, Syed earned 200 total points
ID: 35199480
You might try an area curve to show the grey area. See attached file

Saqib
Graph-with-grey-area.xls
0
 

Author Comment

by:LeiaO
ID: 35199525
Thanks but how do I actually do that??
0
 
LVL 43

Expert Comment

by:Saqib Husain, Syed
ID: 35201059
You can add two additional lines of data to the chart as I have done in rows 16 and 17. These will show up on the chart as lines similar to the existing series. Select them one at a time and change their chart type to "Area". Also suppress the series markers and change the color to suit.

Saqib
0
 
LVL 24

Expert Comment

by:Tracy
ID: 35821688
This question has been classified as abandoned and is closed as part of the Cleanup Program. See the recommendation for more details.
0

Featured Post

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

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!
This article describes a serious pitfall that can happen when deleting shapes using VBA.
The viewer will learn how to use a discrete random variable to simulate the return on an investment over a period of years, create a Monte Carlo simulation using the discrete random variable, and create a graph to represent the possible returns over…
The viewer will learn how to create two correlated normally distributed random variables in Excel, use a normal distribution to simulate the return on different levels of investment in each of the two funds over a period of ten years, and, create a …

834 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