Related Posts
Anyone else on the RSR call today?!
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.
Guys pls advise me, urgent query

I love Secret Santa exchanges at work. Bahaha

Additional Posts in Excel Genius
Anyone know what these badges are?

Would anyone be willing to teach me vlookup?
New to Fishbowl?
unlock all discussions on Fishbowl.





Coach
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.
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!