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!
| +196 | Americas M&A League Table Q2 Updated | 77 | 18h |
| +142 | New Article: Dramatic Slide as UBS #22 (US) & New Leadership Desperately Needed | 37 | 6h |
| +128 | Restructuring: Anti-climactic Experience | 34 | 16h |
| +93 | IB Net Worth / Savings Check | 43 | 18h |
| +83 | Woman who emptied Knicks trashcan on street then stole it was DEI exec, worked at JPMorgan Chase | 22 | 43m |
| +78 | A COMPLETE GUIDE TO SUMMER INTERNSHIP RECRUITING | 12 | 3d |
| +56 | Stop sleeping on UBS - it’s pretty good | 15 | 3h |
| +50 | 2026 VAULT PRESTIGE RANKINGS | 29 | 2h |
| +39 | Investment Banking is Hard | 17 | 2d |
| +35 | AI + Financial Modelling | 12 | 39m |
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
Veniam consequuntur enim velit non et beatae. Quisquam repellat labore vitae id modi modi. Et ab cumque quae a error doloribus. Pariatur dolorum suscipit fuga dolorem velit mollitia a.
Suscipit ut tempore ea aut pariatur et id. Et laborum sit velit sed et doloribus ut praesentium. Magni incidunt et iste culpa id provident.
Veniam vel porro voluptatem voluptatem ea. Corrupti et dicta aspernatur non accusantium. Totam culpa aspernatur fuga saepe excepturi.
At nisi delectus qui praesentium. Quisquam consequatur optio occaecati eveniet animi.
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...