How to make buttons to show and hide a chart in excel

preview_player
Показать описание
How to show and hide a chart using VBA in excel.

Sub hidechart()

ActiveSheet.Shapes("Chart1").Visible = msoFalse
ActiveSheet.Shapes("hidebox").Visible = msoFalse
ActiveSheet.Shapes("showbox").Visible = msoTrue

End Sub

Sub showchart()

ActiveSheet.Shapes("Chart1").Visible = msoTrue
ActiveSheet.Shapes("hidebox").Visible = msoTrue
ActiveSheet.Shapes("showbox").Visible = msoFalse

End Sub
  1. Karina Adcock
  2. toggle button show hide chart excel
  3. visible invisible chart excel
  4. chart appear and disappear in excel
  5. make show and hide chart buttons in excel
  6. show and hide buttons in excel
Рекомендации по теме
Tutorial - How 0:00:57

Tutorial - How To Make Pokemon Pin-Back Buttons

How to make 0:10:25

How to make Wooden Buttons | Handmade olive tree wood buttons

Make Fabric Buttons 0:02:51

Make Fabric Buttons | With NO kit or machine | Fast, Easy, Simple Tutorial

DIY Easy Fabric 0:00:37

DIY Easy Fabric Covered Buttons

How to make 0:03:08

How to make Covered Buttons

HOW TO MAKE 0:01:30

HOW TO MAKE BUTTONS IN *PLS DONATE*.. [NEW 2024⏰]

Everything you didn't 0:04:25

Everything you didn't know you need to know about buttons

Making a Yorkshire 0:10:25

Making a Yorkshire Flower button / New ideas with Yorkshire Buttons - easy tactile button tutorial

Learn HTML buttons 0:05:07

Learn HTML buttons in 5 minutes 🛎️

Make Money Making 0:03:45

Make Money Making Buttons and Pins!

Making custom buttons 0:00:28

Making custom buttons with button maker NO SUBLIMATION REQUIRED!

How to Make 0:17:26

How to Make Fabric Buttons at Home without a machine (plus professional tips) - great for embroidery

Intro to Vevor 0:05:24

Intro to Vevor Button Machine | How to Make Buttons

Make your own 0:08:24

Make your own buttons tutorial | Collaboration with Junk Journal Joy

Button Christmas Tree 0:07:46

Button Christmas Tree Ornament - DIY this easy ornament made of buttons, beads, and wire

Making fondant buttons 0:04:34

Making fondant buttons How To Cake Decorating Turorial

✨Making HOLOGRAPHIC Buttons 0:11:47

✨Making HOLOGRAPHIC Buttons & NEW Button packs!✨

How to make 0:13:06

How to make your own buttons for craft projects (not clothing)

DIY BUTTONS/PINS/FLARE | 0:04:30

DIY BUTTONS/PINS/FLARE | Easy & Affordable

How to make 0:05:57

How to make 2.25in Pinback Buttons using Press Machine.

Learn Python tkinter 0:11:40

Learn Python tkinter GUI buttons easy 🛎️

HOW TO MAKE 0:04:44

HOW TO MAKE BUTTONS! (using upcycled materials)

How I Create 0:00:20

How I Create Buttons on Figma - Figma Snacks

How to ADD 0:05:59

How to ADD BUTTONS to ANY Door! [Minecraft Bedrock 1.21]

Комментарии
Автор

Clever, quick and simple. I would have spent an hour or so struggling thru without your crisp and concise explanation.
Thank you.

gregoryolsen
Автор

Just what I was looking for. I'm about to make a presentation and wanted to explain the concept before showing the chart. As Roy said the perfect touch is having the Show/Hide buttons appearing to toggle. Thank you very much.

davetattersfield
Автор

Thanks for this. It's exactly what I need to do for a customer today. I especially like the bit where you put the Show and Hide boxes on top of each other so it looks like there's just one box.

axfordra
Автор

May God Bless you. Very useful, crystal clear.

deepakchander
Автор

God bless you for teaching this. It helped me a lot.

rishikulshrestha
Автор

This was an excellent little clip. Very handy. A big thank you for your time and effort.

fragranceenthusiast
Автор

This worked perfectly! Easy to follow video as well. I would like add another layer to this. I would like the SHOW button to only display the chart, if all cells in a selected range are not blank. If any blanks, then throw a message requiring that range to be complete. Do you have any suggestions on how I can achieve this? Thank you

smitha
Автор

I have added 5 charts and used the shown technique making show and hide buttons for each chart. Can you pls help if there is any solution to show only the latest chart on the top of the visible charts. Thanks.

ananddez
Автор

I have a small project in excel. Will hardly take 30 mins for you. I'll pay you for work and you can put that project in YouTube also. Please provide your email if possible.

rishikulshrestha