Add "recession shading" or dates highlighting to charts (aka Banded regions)
It's cumbersome to add "recession shading" or period highlighting to a chart (see Peltier's method: http://peltiertech.com/highlight-certain-time-periods-in-a-chart/), but it is very common feature in time series economic analysis, and most people just don't bother, draw a transparent rectangle over the chart and align it manually.
Please add a range highlighting option for charts with a date x-axis.
This is great feedback. Supporting this feature is something we are actively discussing. Please continue to vote on this feature suggestion which will increase its likelihood of getting in the product.
Just to avoid posting a new 'idea' that was similar to others, I cannot support this enough. Shading on a graph is so valuable.
Plotting the 'uncertainty', 'error margin', or 'confidence' about a nominal curve is something so common in so many fields that I was surprised to discover how tedious is was to replicate in excel. There are a bunch of chart types that would rarely be used compared to this. The following link is the best workaround available:
Unfortunately it doesn't work for charts with logarithmic scales:
I am by no means as clever as Microsoft Excel's developers, but suspect this would be such a low hanging fruit. Hopefully it can be part of Excel 2018. It would of been better to stay in Excel for deployability and familiarity for my colleagues but for now, I am being forced to consider developing some tools for my team in Jupyter.
Kenneth Barber commented
XY graph with colored bands to group periods: quarter, semester, hours, days, weeks.
This is possible with a graphical histogram but with only one value by period .With 3 values for a single period, the width is three times as wide.
SOmething like http://exceluser.com/excel_dashboards/seasonality-sales.htm for a XY chart.