How can I add names/a legend to this chart? After I add names, I will want to distinguish between two types of companies via color (eg, old companies vs new). Any ideas? On a Mac if that matters

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

I’d separate both results.

Instead of having only one column with the EV/LTM results, I would create 2 columns. Where column one would be the EV/LTM from the old companies, and column two with the EV/LTM for the new ones.

When you create a chart from these columns you’ll be able to edit the colors for each of them.

like

Below

Post Photo

Related Posts

Any advice for staying concentrated? I’m constantly getting distracted by anything and everything. 😣

like

If I passed my CISA exam but haven’t met the years experience part yet to receive the certification should I still put CISA on my resume? If so, any tips on how?

Anyone ever interview with a firm covid times and not have a video call? Second to final round and everything has just been a phone call so far.. seems little odd and it’s a f500 company

like

Hello All - looking for links, resources , samples on interview prep/practice for sales , account management, partner management, practice management at FAANG companies like amazon, google, microsoft

like

Chances at SOM, Tuck, Fuqua, Darden? 3.7 from T100, 324 GRE (162/162), white lgbt male, 4 YOE with two promotions, on “young executive board” and 6 years of committed extracurricular

like

Is buying fancy condos with high HOA(>$1k) worth it?

like

What's the one thing for you that turns a house into a home? Or one thing that can always make a house feel homey?

like

Anyone with experience in the short term rental space willing to connect?

I was in the market for a first time home in New York but the market and rates got too out of hand. Recently pivoted to a few out of state options for an STR and would love to learn from someone who's set one up.

Thanks!

like

Curry 4's low key 🔥

like

TEARI spot bonus - Was told by my counselor that there’s cash coming for our group bc we’re 59% above plan and 5% YoY. Paid 10/30

like

Looking for a good Feedback 360 service or similar to goal and reward my growing team. Anyone know of a good platform?

like

How much hike and bonus did everyone get at PWC India??? Seeing mad gratitude posts on LinkedIn

like

Let's settle the debate, where to get the best pierogies in Pittsburgh?

like

Hi I am a Tax Analyst in EY GDS for my career growth what are the things I should give importance. By when do we get salary hike usually? EY.

like

Noob plaintif-side L&E lawyer here—how long should I wait for defense counsel to stall on a demand letter before I start getting ready to file?

like

Is Tableau it Power BI better for dashboards? You cannot really do true dashboards in Excel.

like

Hi,

Can we use 10(10AA) leave encashment as tax exemption if we separated from the Job?

Note: corresponding tax paid challan info available in form 16

Thanks

Hi,
After technical rounds, HR asked me to submit the documents and BGC related forms. I sent the all documents, it's been one week and no call back. Usually how much time they will take ?

like

Anyone can Refer me for a specific job I'd in Accenture?

like

What will be the in-hand salary, for below 👇Wipro Accenture Capgemini

Post Photo
like

Additional Posts in Excel Genius

This is dumb, but. How can I pull and average the numbers in column b associated with the 4 values in column a? So, (sum of all As/total number of As) without filtering?

Post Photo
like

Out of curiosity, what percent of your work/analyses are Excel based? And what other softwares do you use the most (Tableau, PowerBI, Alteryx, etc.)

My work has been 90% Excel based 10% Access/SQL based and friends at other firms seem to be using way more advanced programs.

like

Hey guys, I have a Google spreadsheet where each cell has multiple links separated by semi-colons.

How would you get the links to show up in different rows WITHIN a cell? (Pictured is what I want to achieve).

Thank you so much🙏

Post Photo
like

Why don't recent grads know how to use excel?

likehelpfulfunny

Anybody know if there is a way to automate a Gantt chart in excel when building out a roadmap? Essentially want to recreate the functionality of ms project because my client does not have project and wants a nice visual for the roadmap

like

What are your top Excel ninja tricks? Ones that few people know...

like

Hi! I need to give indexes and I compare -322 with 5. The formula I use is iferror(-322/5*100) but the index I get is -6399. This is the only account with that strange difference. Is there something I am not seeing? Because I approach all of them in the same way.

like

Today I encountered the strangest bug I have ever seen with Excel+Thinkcell. I have, as always, a separate Thinkcell sheet where I gather and structure the data (from other sheets) I want to make charts of. However, when linking this data to charts, all formulas in the sheet turns into values. This has never happened before. Anyone else seen this and knows what is going on?

like

Hey fishies, looking for some help with the below

I have 4 lots of data categories which are assigned a code in the adjacent cell
Eg:
Cell A2= 'xyz' Cell B2 = 'w1'
Cell C2= 'ghi' Cell D2 = 'x1'
Cell E2= 'plm' Cell F2 = 'y1'
Cell G2= 'mhn' Cell H2 = 'z1'

The combination of the 'W','X','Y' and 'Z' codes identity a specific trend
I am extracting data which includes multiple combinations of these codes. What is the best way to show frequency of the codes against the category it is assigned to

like

What would you consider "Advanced" or "Expert" level Excel usage?

like

Does anyone know what purple tables mean in Excel?

I know about green and orange, but never saw purple before and trying to figure it out.

likefunny

What's a simple way to explain data organization to people who don't use formulas very often? People on my team love creating many tabs instead of adding columns for recording the same type of data...

like

What’s the best way to summarize multiple amortization schedule. I have each schedule on a separate tab. On a master sheet can I do something where I can input a specific month and show my ST/LT ...

like

Can anybody recommend any excel courses to take for financial analysis? Modeling, valuations, etc. Any direction would be helpful.@

likehelpful

Any suggestions for a formula to calculate a running count of the number of incidences in a list? For example, in a list with A, B, C, B; I want to label A = 1, then the first B =1, and first C = 1, and then the second B = 2, etc. The list is in a column and there are thousands of names. TIA for your help!

What is the best online tool to pick up VBA?

likesmart

I have a large dataset in PowerBI (7m rows) and I’m trying to condense it to pivot in Excel by aggregating the data. Does anyone have experience doing this? How do you pivot and export in Power BI?

like

Each country has multiple txns. Some complete, some not. What formula should I use to say if Indonesia has ANY “not complete” then show me the term “not done”. Tried IF(Index Match) but only (cont.)

Post Photo
like

Does anyone know any shortcuts for the “Refresh All” button without having to always click Data->Refresh All every time I want to refresh the live data? For a Mac btw pls thanks!

Post Photo
like

I created a macro to help me save time on this onetime task and now whenever I open my excel, a blank excel opens with the name of the macro. How do I get rid of it?

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

Scan your QR code to download
Fishbowl app on your mobile

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