Does anyone have the lifesaving knowledge to format/edit charts in excel 2016 w/o the mouse
Seriously has anyone figured this shit out yet? It's killing me. My firm went to excel 2016 and now when I go ctrl + 1 to edit charts I cant FUCKING cycle through the chart options using the tab key etc. From what I've gathered so far, YOU CAN BASICALLY ONLY USE THE FUCKING MOUSE TO EDIT THE STUFF WITHIN THE CHARTS. This shit is killing me. Yes I understand you can still technically move around without the mouse within the popup but nowhere near as efficiently.
Essentially what I'm asking is if anyone knows how to restore the pop-up window (like the one that pops up when you hit ctrl 1 to format anything else in excel) for formatting graphs that was there in previous versions.
If anyone knows how to revert back to the excel 2010 settings (without reverting back to excel 10) where you can actually cycle through and change chart colors, axes, etc. like you can for everything else in excel I will throw you every silver banana I ever earn from here on out and probably give you a third of my bonus
is this some kind of intern challenge
No its not a fucking intern challenge its me on the verge of breaking my keyboard because I hate excel 2016 and just want 2010 back because its taking 4x as long to format shit on graphs
I'm guessing they upgraded due to security issues? You're fucked bro you need to reinstall 10 as nothing else offers the same functionality.
Damnit this is what I was fearing. Yeah something like that from what I understand redownloading isn't in the cards
Using the mouse! So beta!
Firm just did the same, not the answer I was hoping for...now I understand the pain my associate use to talk about from the 2003 to 2010 update. On another note, does anyone know if there is anything beneficial about Excel 2016 relative to Excel 2010?
Minimal... the only thing I heard (specific to charts) is that you can create flying brick charts (e.g. bridges) in excel 2016. I'm still on an older version of excel so can't verify though
This isn't exactly what you were asking for, but if you need to do a bunch of graphs all in similar format, do one manually, then you can alt e s t the rest of the them so the format matches the first one. Saves a ton of time.
Obviously alt e s t is pretty widely used for text and numbers but until recently I had no idea it worked for charts and graphs as well.
Beatae vel qui sapiente consequatur reprehenderit est aut. Rerum quibusdam nemo qui id sunt magnam excepturi. Sint fugiat sit laudantium eligendi enim omnis.
Magnam nisi voluptas doloribus perferendis architecto laudantium. Voluptatem est eos aspernatur voluptatem ipsa. Cupiditate perspiciatis facere ipsum necessitatibus optio. Voluptatibus qui dolorum exercitationem atque placeat animi. Officiis ut pariatur in quia excepturi distinctio praesentium quos.
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...