How to shade squares in chart in ppt for mac
- How to shade squares in chart in ppt for mac how to#
- How to shade squares in chart in ppt for mac full#
- How to shade squares in chart in ppt for mac code#
- How to shade squares in chart in ppt for mac series#
- How to shade squares in chart in ppt for mac mac#
This chart shows the variance (industry average-productity) at bottom so that we can easily look at overall trend & understand how we fared with respect to industry.
How to shade squares in chart in ppt for mac series#
Is this the only way to compare productivity with industry averages?Īlthough our shaded line chart is an excellent way to visualize differences between 2 series of data, I kept thinking if there are other ways to compare this.Īfter a bit of doodling & drawing inspiration from various charts I have seen earlier, here are 4 more options we can consider. This will make the chart look really awesome. You can also move around the legend and remove the words “min” from it. Format lower & upper in green & red colors respectivelyĪnd you are done! Optional: adjust series formatting, add grid lines etc.Īs a bonus, you can add vertical grid lines (so that we can understand the red green changes easily) and format the horizontal axis. Select min series and fill it with “No color”Ħ. Right click on productivity series and using “Change series chart type” option, change it to line chart. Select all the 4 series (productivity, min, lower & upper) and create a stacked area chart.Ĥ. Create a stacked area chart from this data average and productivity (or NA() if negative)ģ.
The above chart tells us where we are lagging and where we are good. But if we can shade our productivity line in red or green when it is under or above industry average… now that would be awesome! Something like below:
How to shade squares in chart in ppt for mac full#
Merely seeing both your series as lines (or columns etc.) is not going to tell you the full story.
How to shade squares in chart in ppt for mac code#
For Windows users, use the Alt Code method by pressing down the key whilst typing the symbol alt code which is 0178.
How to shade squares in chart in ppt for mac mac#
Using the Squared Symbol Shortcut (Mac and Windows)įor Mac users, the keyboard shortcut for the Squared Symbol is Option + 00B2. This is how you may type this symbol in Word using the Alt Code method.
How to shade squares in chart in ppt for mac how to#
The quick guide above provides some useful shortcuts and alt codes on how to type the Squared symbol on both Windows and Mac.įor more details, below are some other methods you can also use to insert this symbol into your work such as Word or Excel document.