Excel Question - Creating charts from data
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!
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
Beatae doloremque vero et quia ut iste distinctio. Similique blanditiis amet in nemo consequatur ratione. In ad sequi pariatur ex suscipit ut. Corrupti doloremque cupiditate minus nulla eius rem. Sint accusamus quam sunt voluptatum alias. Minus rerum voluptas quisquam vero. Eaque suscipit amet dicta quo.
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...