Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #2  
Old 03-18-2025, 08:28 PM
Logit Logit is offline Creating a Chart with a Shaded Field in Excel 2000 Windows 10 Creating a Chart with a Shaded Field in Excel 2000 Office 2007
Expert
 
Join Date: Jan 2017
Posts: 591
Logit is a jewel in the roughLogit is a jewel in the roughLogit is a jewel in the roughLogit is a jewel in the rough
Default

Here's a suggestion :

Steps to Create a Shaded Field:
Prepare Your Data:

Add two new columns to your dataset: one for the "Low Limit" and one for the "High Limit."

Populate these columns with the respective values for the lower and upper limits for each data point.

Calculate the Shaded Area:

Add another column to calculate the difference between the upper and lower limits. This will represent the height of the shaded area.

Create a Stacked Area Chart:

Highlight the "Low Limit" and "Shaded Area" columns along with the dates.

Go to the "Chart Wizard" and select the "Area Chart" type.

Choose the "Stacked Area" subtype.

Format the Chart:

Once the chart is created, right-click on the area representing the "Low Limit" and set its fill color to "No Fill" to make it transparent.

Format the "Shaded Area" with your desired color to represent the range between the limits.

Overlay the Original Data:

Add your original data series (e.g., hemoglobin levels) to the chart by right-clicking and selecting "Source Data."

Ensure the original data is displayed as a line chart on top of the shaded area.

Adjust the Axes and Labels:

Format the axes and labels to ensure the chart is clear and easy to read.

This approach will give you a visually appealing shaded field between the upper and lower limits, replacing the lines.
Reply With Quote
 



Similar Threads
Thread Thread Starter Forum Replies Last Post
Creating a Chart with a Shaded Field in Excel 2000 Advanced Word: Creating shaded headings/separators theconsumer1 Word 1 01-21-2017 10:09 PM
Creating a Chart with a Shaded Field in Excel 2000 Creating a new tab with different kind of chart aaslezak Visio 1 08-25-2015 07:08 PM
Creating new field in pivot table based off existing field laceymarie1987 Excel 0 06-26-2014 12:13 PM
Export resource custom field to excel chart jtorres Project 0 03-15-2011 05:16 AM
Creating a Chart with a Shaded Field in Excel 2000 Creating Scatter XY chart in Excel 2007, modifying the Y axsis niss3 Excel 1 10-27-2010 07:41 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 04:44 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft