Excel Chart Axis Switch - Cool Trick for Comparing Multiple Charts - My Online Training Hub
video description
Date: 2022-04-08
Related videos
Comments and reviews: 10
Ian
That's AWESOME...
Learnt to use -Form- Controls instead of -ActiveX- Controls - I REALLY didn't want to change one drop-down box control to manual entry on an existing Excel form.
This way IT won't block .xlsm files all the time
Thought I knew excel until I started watching your Videos
Fast pace is great - as always content is excellent to enable rewind & figure out how you did something
THANK YOU VERY MUCH
reply
That's AWESOME...
Learnt to use -Form- Controls instead of -ActiveX- Controls - I REALLY didn't want to change one drop-down box control to manual entry on an existing Excel form.
This way IT won't block .xlsm files all the time
Thought I knew excel until I started watching your Videos
Fast pace is great - as always content is excellent to enable rewind & figure out how you did something
THANK YOU VERY MUCH
reply
Cherian
Another sneaky solution Mynda! Very nice and always great content team! Thank you for sharing
TIP - at the 01:29 mark, you copy paste the MIN function to generate the MAX function
You can do it faster using the CTRL + ' [apostrophe] shortcut on the cell immediately below
It will place the same formula as the above cell and also respects absolute / relative cells
Best wishes!
Cherian in Abu Dhabi
reply
Another sneaky solution Mynda! Very nice and always great content team! Thank you for sharing
TIP - at the 01:29 mark, you copy paste the MIN function to generate the MAX function
You can do it faster using the CTRL + ' [apostrophe] shortcut on the cell immediately below
It will place the same formula as the above cell and also respects absolute / relative cells
Best wishes!
Cherian in Abu Dhabi
reply
Bart
Thanks Mynda. A very nice solution for an annoying problem. Please use your influence as MVP to convince Microsoft that the min max setting to achses should be possible to a cell reference. It is on the user voice Excel for many years...
reply
Thanks Mynda. A very nice solution for an annoying problem. Please use your influence as MVP to convince Microsoft that the min max setting to achses should be possible to a cell reference. It is on the user voice Excel for many years...
reply
Narendra
Fantastic idea.. Just 1 thought to share - we could also create a simple drop down box - with these 2 options. So we may avoid the radio buttons at all. However, it looks visually very nice with radio buttons & formatting
reply
Fantastic idea.. Just 1 thought to share - we could also create a simple drop down box - with these 2 options. So we may avoid the radio buttons at all. However, it looks visually very nice with radio buttons & formatting
reply
Patrick
I love clever solutions and this one qualifies! I especially like the quick aside regarding the use of ActiveX controls forcing you to save the file as macro-enabled. Simpler and fewer hurdles is definitely better.
reply
I love clever solutions and this one qualifies! I especially like the quick aside regarding the use of ActiveX controls forcing you to save the file as macro-enabled. Simpler and fewer hurdles is definitely better.
reply
ripudaman
Amazing, but I have plotted lot of pivot tables. When I was trying to create multiple charts from 1 pivot, getting lot of issues like excel slow down like anything. Confused how to incorporate this.
reply
Amazing, but I have plotted lot of pivot tables. When I was trying to create multiple charts from 1 pivot, getting lot of issues like excel slow down like anything. Confused how to incorporate this.
reply
Chazy
Mam, i've got problem in PowerPoint every time I insert Data in any Graph it moves and make the data complicated and i try to start again inserting the data...kindly pls help me mam..thank you
reply
Mam, i've got problem in PowerPoint every time I insert Data in any Graph it moves and make the data complicated and i try to start again inserting the data...kindly pls help me mam..thank you
reply
Wayne
Hi Mynda. Super clever and functional visual! Love the tricks to dress up the radio buttons which are oh so 1990s in default :)) Thanks for demonstrating. Thumbs up!!
reply
Hi Mynda. Super clever and functional visual! Love the tricks to dress up the radio buttons which are oh so 1990s in default :)) Thanks for demonstrating. Thumbs up!!
reply
Nick
Great ideas Mynda. Love the use of shapes to add some design elements. The way you think your way around this program is another level. Respect!
reply
Great ideas Mynda. Love the use of shapes to add some design elements. The way you think your way around this program is another level. Respect!
reply
Deniz
Cool trick but first we have to fix all axis min values to 0 in order to stop excel to change the minimum according to new data series.
reply
Cool trick but first we have to fix all axis min values to 0 in order to stop excel to change the minimum according to new data series.
reply
Add a review, comment
Other channel videos
