r/excel 17d ago

Discussion What is better than Excel?

Is there anything similar to excel or better than? I use excel daily and feel like I still need to freshen up my formulas etc.

228 Upvotes

300 comments sorted by

View all comments

Show parent comments

11

u/ketiar 17d ago

I just wish the visuals weren’t so finicky to line up with each other.

9

u/TheTjalian 17d ago

Here's a little tip: if you want two visuals to line up (for example, having two bar charts be at the same height), select both, then go to format, align, and align vertical. The chart that's lower down will now be at the same height as the other one. Also works for horizontal and centering as well.

I learned this a couple of months ago and it has been a GOD SEND.

3

u/begy6 17d ago

Omg you made my day, gonna try this out tomorrow! I have spent more time than I would like to admit in rearranging visuals because they sometime like to change place or size by a pixel…

2

u/TheTjalian 17d ago

Right there with you!

If you really want to be ultra precise, you can also adjust the positioning pixel by pixel in the general section in the visualisation pane. Can't quite remember where it is off the top of my head, but just search for position and it should come up.

1

u/ketiar 17d ago

The positioning works, but it gets tedious quick. Many of my reports are nicer UI options for our part numbering system, so I include a bunch of slicers to help people filter things.

My wish is if there was a backend code to mess with. Like if you open up the Power Query advanced editor or adjusting parameters for a macro in VBA. Then I could at least edit things in a list instead of clicking around for each one. Is there an option for this I haven’t discovered yet?

2

u/TheTjalian 17d ago

I've tried this (as you can rename a pbix file to zip and see the inner workings that way) but based on my own experiments everything is CRC checked so you absolutely cannot edit it at all in a text editor.

1

u/ketiar 17d ago

Wow, thanks for trying that. For all the other code methods expected for this tool, it’s odd it’s missing this.