Hi-I am creating charts from data that is over time (over the past 25 years). I would like to have my chart show vertical shaded bars where there were recessions over that period (i.e. 91-92). Is there a way to do this automatically without manually and sloppily trying to draw it in myself? Thanks!
| +291 | UBS Tech MD hires Son (from no-name college) as an Intern | 50 | 9m |
| +129 | Is banking in the south more sustainable? | 32 | 6m |
| +102 | The Intern Starter Pack | 19 | 2h |
| +76 | [Official] 2026 IB Analyst Bonus Megathread (with 2025 Consolidated Pay and Perks/Benefits) | 11 | 23h |
| +55 | Perella Weinberg to Cut 10% of Workforce, Including Partners | 35 | 13h |
| +43 | Are all Tech / TMT groups sweaty? | 24 | 1h |
| +40 | UBS Groups Ranked by Future Outlook | 20 | 3d |
| +37 | Is DCM actually underrated ? | 14 | 2h |
| +33 | PWP Layoffs????? | 18 | 5d |
| +32 | UVA McIntire vs Cornell Dyson for IB | 19 | 22h |
Career Resources
Get instant access to lessons taught by experienced private equity pros and bulge bracket investment bankers including financial statement modeling, DCF, M&A, LBO, Comps and Excel Modeling.
are you looked to have all the data as vertical bars and then the recession periods be shaded or what ? If just the ones shaded that you chose then select the specific bars and change color
No I'd like to have all the data as a line graph and then the recession periods shaded ideally.
so all as a line graph and then recession periods with vertical shaded bars ? Then try and create two graphs and superimpose the line over the bar graph or vice versa ....that might be a quick fix
Plot it as a secondary axis, with 1's and 0's. Then set the secondary axis maximum value to 1. The result will be shaded areas were there are 1s. Play with the formatting to adjust to your liking (such as, overlap 100% and various transparencies).
This is right.
To the OP: wherever you want a shaded bar on your graph, put a 1 next to that specific date in time in your data series. Leave blank the other areas (where there were no recessions). Then graph that second column (where there are 1's and blanks) and change it to the secondary axis. Then change the chart type to a bar chart and adjust the secondary Y axis to a maximum of 1.
@hockey1316-yes. I could try that but I am doing this about 15-20 times so that would be ultra-tedious. Not a bad idea though and that will be my backup plan.
@pplstuff-never done this before. Where do I add a secondary axis?
Thanks guys
Excel question - x-axis on a chart (Originally Posted: 11/25/2014)
Trying to make the labels lay out diagonally rather than horizontal. Thoughts? Thanks in advance.
Right Click > Format Axis > Alignment > Custom Angle
Is that what you're talking about?
Only lets you rotate clockwise and stops you at 180, need to rotate counter clockwise.
Use negative degrees?
Thanks, didn't realize it would take negative degrees. Feels dumb
.
Right-click data series, format data series, secondary axis. Excel 2007.
Else: Google
Id aperiam aut accusantium odit maiores laudantium est. In error ut cupiditate magnam odit expedita. Tempora illo aspernatur dolor. Ea et pariatur fugit laboriosam. Id molestiae error quod et ut assumenda. Illum at magni sunt praesentium pariatur.
See All Comments - 100% Free
WSO depends on everyone being able to pitch in when they know something. Unlock with your email and get bonus: 6 financial modeling lessons free ($199 value)
or Unlock with your social account...