MrExcel's Learn Excel #648 - Changing Numbers Graphically

If you like this content, please consider visiting the video on YouTube and subscribe to the MrExcel Channel to show your support!
This video has been published on Mar 26, 2009.
Steve asks if he can build an Excel worksheet where people can change numbers by dragging a graphical element. Episode 648 shows you how you can use a chart in previous versions of Excel to solve this problem.

This blog is the video podcast companion to the book, Learn Excel from MrExcel. Download a new two minute video every workday to learn one of the 277 tips from the book!
maxresdefault.jpg


Transcript of the video:
Hey, welcome back to the MrExcel netcast. I'm Bill Jelen and we have a question that was sent in today by Steve.
I'm Gonna take two days to answer this question.
One method today and another method tomorrow.
Steve said I'm building at a worksheet that someone needs to fill in their budget numbers and basically I want to give them a graphical way to change these numbers rather than have them type in numbers.
They can just be able to you know be nice so they could just grab something on the chart and slide it.
Well if you're, up to excel 2003. They took this feature out of excel 2007.
There's an amazing bit of functionality here.
Watch what happens when I click on for example, the department D.
I get all of the columns in the chart selected, but if I do a second single click, I will now select just column D and I can go to the top edge of that.
My mouse pointer changes to an up and down arrow.
You'll see over here in cell B5. 37410.
If I would drag this to a new spot 45200, it actually changes the number on the spreadsheet.
So we could basically teach the people, Hey, you just have to click and you can drag each department to the new spot and you don't have to type any numbers at all.
Now the big problem with this is basically doing the training.
You'll have to, you know, teach them that the first click doesn't count and it's the second click that actually puts it in edit mode.
This is also really, if you think about it, a dangerous thing, if someone would accidentally click.
It would take a couple of clicks but a couple of accidental clicks on the chart would really have possibly create havoc. So I think that's why microsoft took it out of excel 2007.
That's certainly one option.
Now tomorrow, we'll take a look at using activex scroll bars to solve this problem as well.
Thanks for stopping by. I will see you tomorrow for another netcast from MrExcel.
you
 

Forum statistics

Threads
1,213,497
Messages
6,113,999
Members
448,541
Latest member
iparraguirre89

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top