I have charts and graphs in Excel that I am currently pasting as pic in Word to send out as an internal memo. However, it’s frustrating to resize and reformat every graph to stay consistent each time the memo is distributed. Anyone have a tip on how to create premeasured graph/chart boxes in Word that I can just dump the Excel objects in without resizing and realigning each time?

like
Posting as :
works at
You are currently posting as works at

Do it in R or Python markdown so you can set the image sizes as variables

like

I certainly don’t mean it as a flex; knowing a little code is both empowering and easy enough for anyone in our field to do. I honestly wish it were table stakes!

I learned via coursera and codecademy but if you wanted to be really focused you could google “R markdown tutorial” and go straight to a walkthrough of how to compile markdown documents (I’m not sure which of these are the best, but I’m certain there are many good ones).

Screen shot

like

I liked my own message because it’s still the beat option (pdf works too if it prints right, but screen shot is what you see is what you get)

Ask your company to get you a think cell license, it will save you hours and it will look much better than typical excel graphs

like

My only experience with thinkcell is it taking more time to reproducing worse quality graphs than Excel, then crashing my PowerPoint. I'd rather format it once in Excel to paste appropriately. Or, better yet, drop the slide game and leverage visualization tools.

Fix the formatting in the excel file so it pastes the way you want in word. Annoying the first time, perfect after

like

You could link the data/graphs to your excel file but you will BLOW UP your file size.

like

The multiple tabs and header excuses are kinda bs. I guess try linking the data or formatting the charts in excel exactly how they need to be in word.

Literally download the Macabaus add-on to your Microsoft office suite. That solves every problem you have on sizing/formatting.

like

Correct - but that’s just an example. There are many similar add-ons with these capabilities

Related Posts

It’s Tuesday morning and I am hunting for jobs already. Anyone here experience success with LinkedIn Easy Apply or cold applications on career websites? It feels like a waste of time.

likefunny

Has anyone braved the gym since it reopened out here in SoCal? What are your experiences so far? Currently have LA Fitness since I don’t need much from my gym. But open to upgrade to Equinox if it’s safer/more sanitary.

like

Anyone have chiropractors they'd recommend in NYC?

like

I am a partner in Canada and have been offered a role in USA with a bigger buss unit but a level down in the org chart. I can live anywhere in USA and part time in Canada. My boyfriend can move to USA with me but my daughter is in west coast who is 20. Since Covid I have spent more time with her. I have worked a lot with American partners but not clients. Thoughts on how I would be received as a leader being a Canadian woman in USA. About 2000 people in BU.

likesmart

I have 5 years of experience as an rpa and workday developer. I do not want to be a developer anymore. What are my options?

like

4.5 yoe in audit. have opportunity to move down in rank to valuation for a tiny bit more money in lcol. with that said, i’m up for promo to manager in audit. i hate it - but if i stay i’ll make more money in the meantime and have exit ops to shitty fp&a roles. my question is: is the move to valuation provide any better exit ops? is it worth it at all this late?

like

Suggestions on where one may locate reasonably priced board games in Dubai? Somewhat random but I assume consultants play board games too

likefunny

I (M) am on a budget and need an outfit for 3 summer weddings with very different vibes. Possible to have one base outfit (with variations) for all weddings?

Wedding 1 - very formal. Venue is a museum in a big city, and I’ll be meeting majority of significant other’s family.

Wedding 2 - beach wedding.

Wedding 3 - venue in a small town and reception is an outdoor BBQ.

like

Does anyone access to Epic training tools? YouTube? Lol

like

Any Strategy& 🐠 here?
Has there been any change in date of joining for incoming FTs or interns?

like

Hi All,

Please help me unlock dm, need 11 likes.

likeuplifting

How do you focus on work when looking at new jobs/going through interviews? Finding it really hard… anyone else

like

In a new position, if you didn't like the culture, how long would you stay at that company?

like

Any book recommendations? Mid 20s interested in health, neuropsychology, finance, leadership, and Christianity

like

NEED a good salon in downtown nyc.

I have super thick Sicilian hair and need it cut, layered, etc. I will pay anything for a good and reliable stylist.

Eventually I want to get it balayaged again - I’m blonde if that’s important.

Thank you in advance!! Please post avg cost if you can. 💕

like

Landing in London tonight

Post Photo
like

I asked my brother what he'd like for his upcoming birthday and he replied "plane ticket". Any recommendations for cheap getaways?

like

I’m new on a beat. What are your top tips for sourcing in a predominantly virtual environment?

like

Looking for a role in consulting, 4.5 yoe industry in risk /audit / fintech and 0.5 yoe in consulting, doing a masters at the moment, thanks!

like

Anyone know what a product manager role at a quant fund like two sigma may look like? Is it internal tech or do they work on external products?

like

Additional Posts in Excel Genius

Google Sheets vs Excel - pros? cons? differences?

likefunnysmarthelpful

Can I write a macro that will fill out a table of information based on cells that have comments on them? For example, if G12 has a comment, I want to pull text from that comment + data in A12.

like

What is y'all's preferred clipping tool? One of my former companies had a great simple program that was only like $50 and worth every penny.
Snipping Tool just ain't cuttin' it (lol pun intended).

like

Best pdf to excel converter?

like

Best excel plug in? Currently using Capital IQ and WST

like

Does anyone know how I can conditionally format a table with a sliding scale? I have a value that is supposed to fit in a range. I need the first possible range the number can fit in to be formatted. Thanks

likehelpful

Tips on adjusting to Mac? I’ve figured lots of keyboard shortcuts but it’s just not the same 😪

like

Hey, tips for where to look for good excel cheat sheets online? :)

How do I stop excel from changing the cell reference to a different column each time I refresh the data pull?
The spreadsheet is connected to an API data pull. Each time I refresh the data it changes the cell reference (SCD_0010) to a different cell e.g. (SCD_0127). How can I stop this?

Post Photo
like

Why when I refresh a query, the table where the query is loaded to just gets duplicate rows? Same with the pivot table that feeds off of that query?

like

If you follow him on LinkedIn you probably already saw this! Lol 😆 but I totally resonate with the post... 🤣

Post Photo
funnylike

Just created my first macro! Super proud of myself! #humblebrag

likeuplifting

Is there any easy way to handle FedEx/ups tracking numbers? I’d like to have some formula that would just show the status in another cell.

like

I want to create a heat map of when people are unavailable with day of week as the columns and hour of day as the rows. I have start times and end times, how can I use this data to create the map?

like

I’ve toggled the “Show Formula” setting and it changes nothing. File format is xlsx, so that shouldn’t be the issue. Any ideas why these are showing the formula instead of the output?

Post Photo
like

Any recommend courses (coursera, edx, etc.) people would recommend for user with intermediate experience with excel?

like

At my old firms when I would be using excel and modeling using the font schemes (blue, green, black for hardcode, link, and formula) I could use the “control shift ;” to shift through the schemes. My new firm doesn’t do this. Does anyone know why the shortcut would be different and how I can add it back?

like

Our system is really lacking and we do a lot of work outside of it to track data. Currently I’m using Excel to track data from multiple resources, however, it’s so manual and prone to error. Any suggestions to keep the data clean when I have to pull info from multiple places? I’m constantly auditing and we won’t even look at getting a new system until next year :(

Hi team i have a bit of doubt.
I have an excel sheet where column A is the order numbers. I want to add comments in column G.
There are many repetitions in order numbers but they are all sorted in ascending so all the repetitions are below one another.

If i have a comment, how can i automatically paste that same comment in all the repetitions of that order numbers if i write it in the 1st instance.

Thanks in advance

like

New to Fishbowl?

Download the Fishbowl app to
unlock all discussions on Fishbowl.
That was just a preview…
Sign Up to see all discussions
  • Discover what it’s like to work at companies from real professionals
  • Get candid advice from people in your field in a safe space
  • Chat and network with other professionals in your field
Sign up in seconds to unlock all discussions on Fishbowl.

Already a user?
Login here

Share

Embed this post

Copy and paste embed code on your site

Preview

Download the
Fishbowl app

See what’s happening in your industry
from the palm of your hand.

A phone with Fishbowl app

Send download link to your phone

OR

Scan your QR code to download
Fishbowl app on your mobile

By continuing you agree to Terms of Use and Privacy Policy.

Messaging rates may apply

Download app

Sign up for free to view this conversation on Fishbowl

By continuing you agree to Terms of Use and Privacy Policy

Already have an account? Log in

Sign up for free to continue using Fishbowl

By continuing you agree to Terms of Use(New) and Privacy Policy(New)
Messaging rates may apply

Already have an account? Log in

For account settings, visit Fishbowl on Desktop Browser or

General

Legal