Scribd
Upload
60 views3 pages

Excel Spectrum Chart Instructions

This document provides instructions for creating a stacked bar chart with movable sliders to represent different project statuses. The steps include: 1. Creating column data for the spectrum and slider fill. 2. Creating slider size column data. 3. Creating the stacked bar chart and deleting slider series. 4. Moving slider elements to the secondary axis and adjusting axis settings. 5. Formatting the slider and spectrum series and deleting unnecessary axes and legends.

Uploaded by

Felicia Ghica
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd
60 views3 pages

Excel Spectrum Chart Instructions

This document provides instructions for creating a stacked bar chart with movable sliders to represent different project statuses. The steps include: 1. Creating column data for the spectrum and slider fill. 2. Creating slider size column data. 3. Creating the stacked bar chart and deleting slider series. 4. Moving slider elements to the secondary axis and adjusting axis settings. 5. Formatting the slider and spectrum series and deleting unnecessary axes and legends.

Uploaded by

Felicia Ghica
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd

Slider Position Spectrum Slider Fill Slider Size

Schedule 6 8 5.875 0.25


PM Status Spectrum
Resources 5 8 4.875 0.25
Implement 4 8 3.875 0.25
Schedule
Training 4 8 3.875 0.25
Rollout 5 8 4.875 0.25
Change these Resources
Values to
move the Implement
sliders

Training

Rollout
Steps
1) Create Spectrum Column Data
PM Status Spectrum
2) Create Slider Fill Column Data
3) Create Slider Size Column Data 0.2
4) Create Stacked Bar Chart
5) Delete Slider Series
6) Move Slider Fill and Slider Space to Secondary A
7) Show Secondary Vertical Axis
8) Check "Categories in Reverse Order" on both ve
9) Change Maximum Bound to 8 on Primary Horiz
10) Delete Both Secondary Axis'
11) Change Slider Fill Series to "No Fill" Color and G
12) Change Fill Color of Slider Size to Grey with Da
13) Change Fill Color of Spectrum - Gradient Fill / R
14) Delete Legend and Primary Horizontal Axis
15) Add Title
umn Data 0.2

ider Space to Secondary Axis

Reverse Order" on both vertical axis'


und to 8 on Primary Horizontal Axis

ries to "No Fill" Color and Gap Width to 50%


Slider Size to Grey with Dark Border
Spectrum - Gradient Fill / Radial / 3 markers / Green Left, Yellow Middle, Red Right
rimary Horizontal Axis

You might also like