I've noticed the last few days that Excel charts are acting differently. It is lumping columns together so that I can't choose individual columns to work with. Have any of you noticed this? How do I work with it this way? I'm hoping to take the MOS test in a couple months, so I need to figure out what's going on. 🙃

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

The chart is combining data from multiple columns into single pieces of data. I'll try out your ideas and let you know!

like

Oops! I didn't see "charts" when I commented. It may be within the chart parameters.

Sounds like you have merged cells

You would think, but they aren't. Each time has been brand new randomly generated data to practice with. And it's been in more than one file. One time I was able to break the combo by editing a field within select data, but it's not particularly convenient.

Is it grouping columns or combining the data in separate columns into one column?

Select all of the spreadsheet.
If the Merge & Center button is highlighted, click it.

If that doesn't fix your problem:

If it's grouping:
Select all of the spreadsheet, go to the data tab, click ungroup.

If that doesn't fix your problem and it has combined data from separate columns into one column, insert the # of columns that should be there after the column with all of the data in it. Then select the entire column with all of the data in it. Go to the Data tab, click Text to Columns. Pick one of the options, delimited there is not a straight cut line down the data where you want to split the data.
Alternatively, you may be able to fill in the columns you added on the first 3 rows with the data each cell should have, and then click in the 4th row in the first empty cell and hit Ctrl + e to fill down. If Excel can pick up on the pattern, it will fill the rest in for you.

Click delimited if** there is not a clear cut line

Here is what's happening. This is randomly generated data, so it's meaningless. I can go into edit series and reduce it down to only the city column, but if I switch the rows and columns, it lumps everything I've excluded in with the gender column in the same way.

Post Photo

Related Posts

This couldn’t be more timely as I’m sitting in the waiting room after just being diagnosed 😆 welcoming tips for adjusting to Adderall!

like

Has anyone’s center discussed closure due to virus precautions? I’m super anxious not about the virus but about all the response to it.

like

When it comes to therapy do I look up a place online and make an appointment or do I need some sort of referral? Not sure if I need to see a therapist or physiatrist really.

like

Best advice for a new therapist? Or something you wish you learned at the beginning of your career?

like

How many therapists (and social workers too!) see a therapist themselves? Do you find it helpful?
I think there's this myth that therapists have all their own sh*t figured out, and for me at least I know that's far from true (hopefully it isn't just me). On the contrary, I think we should be leading by example!

like

Any thoughts on meditation? Has it helped you?

likehelpful

Feeling really low cause I got diagnosed with a serious uncureable disease. Trying to process and come to terms with the implications of it. I wanna go out but struggling to motivate myself to even get out of bed 😔

like

Any meditation stories on recovery anyone willing to share? Did you have break through moments during meditation?

like

We know there are few places in the country that feel like this at the end of October.

Post Photo
like

In the process of interviewing for a strategy/Corp dev position at an activewear/athleisure company and they want me to think of a couple tangential industries that may have companies for acquisition and do a write up. I’m stumped on what else an activewear company would buy besides other activewear companies. I can only think of home fitness (Lulu’s Mirror) or vitamins/supplements. Any thoughts?

like

Anyone have tips on building muscle/doing a clean bulk when traveling 4/5 days out of the week? Thinking about joining a large gym network i.e. planet fitness instead of hotel gym

While the impact of this Coronavirus has been mostly negative, at least one positive is that rare specialty pieces are now much more attainable. AD able to get many even without $ history.

like

Doctor just prescribed Wellbutrin to add onto my adderall. Has anyone tried this combo? What effect did adding Wellbutrin have on you?

like

Interesting. Let’s see if the uptick In cases continues to drive an uptick in hospitalizations and then in fatalities. Depends on how many of the cases are incidental or in very young people not prone to severe cases. But either way, look at the hospital capacity utilization figures! This is the untold story. Were we bending the curve to avoid unnecessary deaths due to overcrowded hospitals, or were we bending the curve to buy time for treatments and vaccine, or just to slow fatalities?

Post Photo
like

Does anyone get so anxious about work that they can’t eat? The thought of food just makes you want to puke? How to manage? Skipping meals/not eating for a day is unhealthy and will cause weight gain

like

Does anyone think covid 19 could penetrate a static warp shell?

likefunny

Pharma Insight Bingo!? I’ll start. “Patients have settled for a new normal.”

likefunny

9/7: What are everyone’s plans for today?

For me- treadmill, chest and shoulders.

likeuplifting

Have you, or anyone you know, gotten covid twice within weeks or months? I’m being told that you can catch omicron 2 weeks after recovering…

like

One thing that COVID-19 has taught you?

like

More Posts

Hey All- looking for a variety of freelance producers- mid level to senior. Hit me up if there’s someone great looking for a gig.

like

If u have a house under my name if i move it to an llc what happens? Do i refinance to prevent a due on sale clause?

like

I was just offered an amazing logistics job in England. At first, I thought Brexit would pose a unique challenge but the more I learn, the more I realize how bad the situation really is. Do you see things improving any time soon?

like

I received an offer for a role that is a lot more money than I thought but I still want to negotiate and see how much more money I can get. What can I say if the salary is already above average for the role in the market and city I live in?

likehelpful

Hi! Does anybody happen to know if Apple offices are dog-friendly? Specifically the Culver City office and Apple Park. Thank you!

like

Hello all,

Please anybody tell me reason to reject our profile in the workday app

I have joined infosys today . Having experience in IoT , Azure and. Net
Is there anyone can guide me to land in azure project in infosys.
I'm not confident the Talent Acquisition or HR team will gave the exact technology as per our Intrest or skill.

What do u prefer

Post Photo
helpfullike

A colleague told me today that Google separates Product Manager and Product Owner as two separate roles. I believe that one PM role is preferred in the industry and most modern software companies, especially FAANG companies, only have PMs. Just curious what others have experienced and if I'm correct in my assumption.

like

Any one recently joined Indeed? Want to know if Indeed asked for a reliving/experience letter from the previous employer. I am joining Indeed in July. I am going through a rough patch with my current employer, ever since I put in my notice 🤦‍♂️ Its got to the point of them threatening to not provide a experience/reliving letter…
I can provide references and recommendations. Before leaving, I just want to ensure that I am equipping my successor to take care of my product and build it further…

like

Which city would you recommend for single men in late 20s trying to find good opportunities in career & dating? Leaning more towards to NYC but not planning to live in Manhattan due to the high rent so I am not sure that would be okay. Also don't want to drive that much.

like

Does EY gives confirmation mail if background check is completed before joining?

likesmart

Hello Fishes, is it common for wipro to extend the doj. Somone i came across his doj was changed from august to october.

like

This is my third cycle review graph, not sure if it's bad or average. Will 5th cycle promotion be possible?

Post Photo
like

Retail workers: are there any staff shortages where you work? Our store is 5 people short so we are all having to work overtime to make sure shifts are covered. It's exhausting.

like

I'm a Canadian on the TN visa working in the US and planning on maxing my Roth IRA (6k) and will have enough left to max my 401k this year, but am not sure if I should just use a taxable account over 401k due to tax considerations when I move back to Canada (likely 1-2 years from now). Any thoughts here? I don't think I'll have enough RRSP room to move 401k>IRA>RRSP and I would prefer to not have to file US taxes every year in retirement for withdrawls if I left the 401k in the US.

like

Might be shifting to a outpatient oncology position from a medical social worker in a hospital setting, any pros/cons major differences?

helpfullike

Hello! What is the best way to structure a discovery call for SaaS sales? e.g. share a deck, only focus on their use case (current state, goals, pain, etc.), share a story, etc. Lastly, how do you go further than surface level, like if they mention they are having issues with xyz, which is usually a symptom of the problem and not the problem itself. Any info would be appreciated, thanks.

like

Hi all, when do y’all think is a good time to have the “what are we”/“are we exclusive” talk? After how many dates?

like

Additional Posts in Excel Genius

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

like

Anyone have an app or Excel spreadsheet they use to keep track of utilization? We just switched systems and our new system doesn’t give us a real time balance of our utilization rate (cont)

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

Will need to migrate to office 365 soon. What’s the difference for excel from the 2013 version?

likehelpful

Is there a way for me to automate creating columns to do this so I can drag across and create my columns? For example--
1Q2021 2Q2021 3Q2021 4Q2021 2021 1Q2022?

likesmart

Anyone know what these badges are?

Post Photo
likefunny

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

Still don't have xlookup. #fomo

like

Anybody have the SQL server data mining add in on excel? Desperately need to run a really quick analysis through it but can’t configure it.

like

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

like

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

Post Photo
likehelpful

Struggling with this:
Suppose I want to shortlist companies that serve the priority industry vertical of a country. So I have the industries served by company (one column for each industry) and (cont)

What are some common reasons that a COUNTIF formula might not be working correctly? I'm using the correct range and value to count. I'm not seeing "ERROR" but the values aren't correct (it's not counting everything). Thx.

like

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

What are your top excel functions you use in finance / accounting - besides vlookup - Pivots - sumifs - count - index. I have an interview coming up which will have excel based technical questions. Not sure what other functions are considered important in the accounting finance world.

like

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

Hey guys, I'm trying to find a formula to use instead of the Goal Seek function. Anyone know it? I thought I had seen one years ago, but can't find it now.

like

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

like

For a linear regression analysis… the equation of a line is Y=MX+B, where M is the slope. So if I’m measuring a line across 365 days and M=.2, can I say that I have increased production by 20% over a year. Or is production increasing 20% each day?

like

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