Ok excel geniuses, help me Obi Wan Kenobi you're my only hope. I hate charts and graphs, it's my one Excel kryptonite.

I've taken classes and can follow the sample file exercises OK but when I try with real life data it rarely does what I want it to.

Have you ever set up a line chart and you've selected all of your data but not all the lines show up? I can see the legend has captured all three categories but only one is visible and all three have data in the pivot table. Stuck...any ideas?

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

In Yoda's words:

1. Use pivot tables, do not.
2. Numerical, your data must be, not text. Use =ISNUMBER() to check it, you can.
3. The axis limits ensure, that all data can be plotted in the chart's space, do.
4. The most important one, check again, #1 is.

like

I love it!

And you're the first one who ever told me you shouldn't chart off a pivot. All my charts are off pivots but their performance and reliability are....spotty. 😅 That may be the issue. No wonder I'm about to pull my hair out.

I shall try this advice. Thank you Master Victor 👍😅

Just wanted to share an update in case others run into this.

Apparently some of my test data only had one data point (one trx only) so excel could not draw a line.

Changing your chart to Line with Markers makes that incredibly clear. I could now see the forest through the trees and my issue is fixed!

Related Posts

likefunny

Not sure if anyone of you know but we EY india people got excel sheet to fill up for diwali goodies. Has anyone know what we can expect in diwali goodies?

like

Whats the Accenture Digital and Deloitte Digital salary for a Consultant in Atlanta (tier 2 city i think)?

like

Hi,
How does the sapience ibuddy tool work ? What if I'm not able to clock 8 hours ?

like

have an offer for 11 LPA and asked for 14.5 LPA. HR said It is approved by account team and rejected by Capgemini talent acquisition team(Practise end) what does that mean

like

Hi Fishes,
Looking for opportunity as SAP BO developer with 5.8years of experience.Let me know if anything available at Kolkata /Bangalore.(No start ups please)

like

Anyone working on Digital Front Door strategy? I'm building this out for my practice right now. Would love to connect.

like

Anyone else on the RSR call today?!

like

22- Asked to upload document in ibegin
23- Verified all documents
What next ?
Current status as show below on ibegin

Post Photo
like

If anybody is aware of global compliance process for international travel request, kindly help me with the timeline and while process?

I have already uploaded COC Application onto EPFO portal after verification from TCS compliance team and now status shows as waiting for employer’s approval.
Does anyone has idea how long more will it take to complete this and what are the next step?
My travel date is in the second week of November and other clearances are dependent on this check.

Are there UK firms hiring right now or more likely to give tier 2 visas? I'm a US citizen w/ 4 years experience at Deloitte, UK uni & hoping to stay (exempt from res labor market test)

like

How muxh time do the HR take to release the round 2 interview results?
Is it possible to not get the mail if i havnt cleared the round?

like

Hi All. I have offers from MobiKwik and Target for the role of Data Engineer.
Which organisation should I go fo?r. Please consider factors like job security, work quality and learning, WL balance and office culture.
They're both offering similar CTC and location is preferable in case of MobiKwik. My YoE is 3.

I cleared the interview of Tech Mahindra and got mail to submit the documents.

I have 6.7 years of experience in a niche technology. Current package is 14.5lpa.
My interview went good.

How much should i ask for ?
And, will i get the offer after i submit the documents?Tech Mahindra

Today my supervisor told me "be helpful with customers, but not TOO helpful." I seriously have no idea what that means. OK though, you're the boss?

like

I have several job offers I am considering. My dilemma is when I put my resignation in for my current employer should I tell them why I’m leaving? (Toxic environment passive aggressive behavior from superiors
And staff that habitually didn’t do their job thoroughly and I was prohibited from writing them up?) thoughts?

like

Guys pls advise me, urgent query

Post Photo
like

I love Secret Santa exchanges at work. Bahaha

Post Photo
likefunny

Anyone have advice on getting your foot in the door at Google or Meta for a Sales Role? I’ve only got 3.5 years of experience but have achieved Presidents Club and have had success at 2 “blue chip” organizations.

like

Additional Posts in Excel Genius

I’m calculating a bunch of totals and averages by category on one worksheet by filtering data in different categories from another worksheet. However, when I change the filters, the previously..(cont)

Timesaver: If you’re working on a file saved on the cloud (teams, share point, etc.) and need the URL to communicate out, tap FILE -> INFO -> COPY PATH and the url will be on your clipboard. Pre-established sharing privileges of orig folder will apply. Hopefully this saves you time reshuffling open windows! Bonus: Same on standard MS suite files.

likesmart

What’s the keyboard shortcut to get into the “insert options” dialogue when you’ve inserted a new row with Ctrl+Shift+Plus?

like

How do I compare two sheets to make sure they are identical?

like

Vlook up isn't recognizing a couple of cells even though it's feeding off a pivot and when I check with an " if =" it comes up as being the same.
Any advice on what I need to check?
Thanks

like

HELP!
I have raw sales data on one tab, which includes a sales rep ID number. My second tab has that sales rep ID number in column 1 and the rep name in column 2. How can I get the rep name added to the correct line items in the raw data?

Anyone know what these badges are?

Post Photo
likefunny

Would anyone be willing to teach me vlookup?

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

Has anyone had an issue with index match and lookups returning NA when trying to manipulate data from a password protected workbook?

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.

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

like

Hi All,
Looking to automate a manual process for the client and thinking of creating macros for with VBA. Has anyone done anything similar?

In the process of learning but wanted to reach out for any tips, tricks and advice anyone may have.

Thanks I’m advance.

like

After I set a print area, how do I showcase the page 1 - page x in the excel sheet and have the background be grey?

I’m verrrrrry new to excel and am going crazy because is there not a way to “clip” text in cells like you can in google sheets? I read about a “fill” option, but then noticed that cells that aren’t filled just repeat text. 😂🤯

like

Best websites to get more of a handle on Excel as a beginner-intermediate?

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

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

Anyone else have a formatting pet peeve and get annoyed when people don’t have a blank first column and row in tabs? I.e headers/data in cell A1

My first manager told me this, and I’ve followed it to a T since.

likesmart

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