Please or to access all these features

AIBU?

Share your dilemmas and get honest opinions from other Mumsnetters.

To think I can do this in Excel?

35 replies

Notworryingdarling · 15/01/2024 13:27

Looking for some help kind Mumsnetters! Not sure if I am missing an obvious way to do this. I have a table in Excel, it's not showing data in a way that needs to be analysed just representing something. So it's a list of criteria down the side, with a list of elements across the top and Xs in certain cells to show which criteria appear in which elements.

I want a more visually appealing version of this to share with stakeholders. Anyone got any ideas on quick simple ways to do this, either in Excel itself or using another (preferably free!) tool? I have visions of being able to upload it somewhere to get a nice visual graphic version but can't find anything that does that, maybe it's a pipe dream and I need to spend time manually making it look good but I thought I would throw the question out there! Any help gratefully received!

OP posts:
SpursFan2 · 15/01/2024 13:40

Good luck! (I hate Excel and have only just started feeling a bit more confident with it 😂😂)

bluechicky · 15/01/2024 13:39

If you don't need to filter it or play with the table then just put it in a table in word. You're only using excel for the square boxes otherwise

SpursFan2 · 15/01/2024 13:39

Could you colour the cells directly (e.g. highlight the cells in different colours) using conditional formatting?

Notworryingdarling · 15/01/2024 13:36

Thanks for the replies. I'm struggling a bit to think of a way to do it in conditional formatting. Colouring the Xs might work thank you.

Its not this , but say its a list if children at the side and a list of classes they are in at the top, with Xs marking which child is in each class. It just looks like a really basic black and white list and I'd love it to look more like a graphic representation if that makes any sense!

OP posts:
TooScaredToPostOnMN · 15/01/2024 13:34

Have you searched a pivot table? You could then put it into graphs

MabelMaybe · 15/01/2024 13:32

How is your side criteria listed? Could you change the order to make it more representative of your message, or so the point you want to make stands out?

xILikeJamx · 15/01/2024 13:31

Not entirely sure what you're looking for.

You could use conditional formatting - create a rule for "Format only cells that contain..." and then the drop downs "Cell value", "Equal to" and then enter X in the final box.

Click the 'Format' button underneath and set the Fill colour and the Font colour to the same. Then for all the Xs you'll get a coloured box with no visible X (although it is still there). Could go column by column and have different colours for each?

bluechicky · 15/01/2024 13:30

Can you use a table in word? Or do you need to be able to filter it?

MereDintofPandiculation · 15/01/2024 13:29

What message do you want your clients to receive? Answering this question will help you decide how to present it.

SpursFan2 · 15/01/2024 13:29

Could you colour code the cells to differentiate between the different criteria? If you click on conditional formatting in Excel, that should give you options to choose from to colour code different cells.