Turning raw data into a clear chart can change how a team thinks about a problem.
What’s your go-to chart for making numbers easy to understand in Excel?

Bar chart, pie chart, scatter plot—or something wild?

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

Really depends on data type to begin with, if a trend needs to be shown then i usually go for line graph esp if time duration is involved, for comparison i use bar charts, for % split i go for pie chart or pareto or histogram

like

Use Power BI instead!

Related Posts

Are there any onsite opportunities available with CTS for payments Business Analyst profile (SWIFT,ISO). Pls need referral

Has anyone made (or know someone) who has made a switch to a strategy or project mgmt role in pharmaceuticals?

like

I have an offer for Consultant Specialist GCB5. Not sure what the role is..is it a team lead role or is it a junior role? I have 10 yoe .. is it apt? Pls help Thanks

Which firms have dedicated infrastructure consulting roles? I'm taking servers, cloud, networks, etc. Is the pay comparable to other tech consulting areas in the same firm?

like

Hi fishes,
I have interviewed for Commerce Cloud SMTS. Results are positive. What base pay range should I expect from Salesforce? YoE 7yrs.

like

I want an advice on which field would be good on both future and salary. CYBER SECURITY ENGINEER OR SOC ANALYST? any advice will be appreciated.

like

Hey guys
How much salary should I ask
For Associate Infrastructure L1 in Publicis Sapient
I have 1 year of experience

like

What are the perks of joining Oracle ? Like Broadband reimbursement, monitor , mobile, wfh set up etc ?

like

Them GME puts

like
like

I keep seeing posts that associates at mid-size/biglaw firms don’t get given the opportunity to go to court. Is this true across most larger firms, even if you lateral with some experience?

like
like

Hi,

I am going through psychological stress, mild depression and anxiety issues due to recent workload and have lost all motivation to continue. I am planning to quit but afraid will i get a job post that. What shall i do?

like

What would be the take home salary for the below structure

Components of Total Cost to Company

Rs. (Per Annum)

Basic (@40% of Total Fixed Pay)

                   771,240.00

HRA (@70% of Basic Pay)

                   539,868.00

Bonus/Statutory Bonus

                      48,000.00

Employer's contribution to Provident Fund (@12% of Basic Pay)

                      92,549.00

Flexible Components of TFP ^

                   476,444.00

Total Fixed Pay (Per Annum)

                1,928,10

like

Currently Talenttree doesn’t have opportunity based on my profile

Help me to choose among following options:

1. How long do I need to wait for the matching profile meanwhile continue doing 201 certifications?

2. Should I resign or no need to because bench period early release might be negotiable?

like

Hi all ,
I am looking for a job in
Accenture in HR (operations) , currently working with KPIT Pune
I have 3yrs of experience.
Grateful for any leads , thanks in advance!

like
like

Hi,
Anyone here about to join Accenture Gurgaon on 14th of November?

How many days in a week are you visiting office?

like

Additional Posts in Excel Genius

I’m referencing a cell (numeric) to a text cell. Is there a way to format that number to include commas? See example in comments.

Is there anything similar to the INDIRECT function that I can use to build a formula reference to another workbook? INDIRECT creates errors when the referenced workbook is closed..

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

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

like

Best way to lookup a value with multiple criteria across rows and Columns, for 3 criteria I usually do sum product. Any other tips?

like

EY trying to move away from Excel . Think it’s possible? Want to see it happen?

like

Current IE here. What are some Time Motion Study Softwares that are out there and you use in your jobs?

like

How do I set the formula to calculate “If x falls between 1-10, return 1-10, if it falls between 11-20, return 11-20, and so on”

like

Need help building an electric schedule for a production schedule with a Gantt chart style view (sort of)

Currently have an excel list with resource (production line), start date and time, and then also the name of the item being produced.

Any ideas how to tackle this??

I’m thinking a stacked bar chart with the vertical categories to be my resources and horizontal the date/time and then each individual bar to be the name of the item being produced.

Thank you for the help Excel Gods 🙏

like

Excel Rookie looking for a super simple formula to bring all information linked to a certain date in tab 1 to be organized under said date in tab 2.

like

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

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

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!

Hey, I have been tasked with teaching some of my coworkers excel from the very basics to more advanced. Does anyone have recommendations on the skills to teach them about? Thank you all in advance!

helpful

Client sent over a 90 MB model this evening. Took 10 minutes to open and a fraction of that to crash. Can’t wait for tomorrow 😭

like

Does anyone have any tips/tricks for knowing where to plug +1/-1 in a large table with totals across the y and x axis that contain un-rounded numbers? Every time I fix a row I throw off a column or my check figures to the true data source.

Post Photo
like

How do you fix microsoft excel cannot paste data error?

like

How can I add multiple characteristics within one cell and make sure that a pivot table can read both values independently if needed? E.g., I have a column titled “color” and in one cell I write “red” and the other “red, blue”. I’d like a pivot table / formula to be able to count that there are technically two “reds” in this data set. Any tips?

like

I am trying to recreate this without the numbers at the end. Any advice?

Post Photo
likehelpful

Is there an easy way to switch XLOOKUPS to INDEX MATCH? Have a large file with bunch of formulas that don't work on all client machines (different excel versions).

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