• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 249
  • Last Modified:

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

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
LeiaO
Asked:
LeiaO
  • 2
1 Solution
 
Saqib Husain, SyedEngineerCommented:
You might try an area curve to show the grey area. See attached file

Saqib
Graph-with-grey-area.xls
0
 
LeiaOAuthor Commented:
Thanks but how do I actually do that??
0
 
Saqib Husain, SyedEngineerCommented:
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
 
TracyVBA DeveloperCommented:
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: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

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

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now