Did you know that you can change numbers in the underlying worksheet by dragging points on a chart? This might be an interesting trick to allow someone to adjust their forecast projections. Episode 634 shows you how.
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!
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!
Transcript of the video:
Hey, welcome back to the MrExcel netcast.
I'm Bill Jelen.
Hey, just a quick reminder.
If you happen to be in England, I have two dates coming up. Monday, 19th November, I'll be in Manchester, and then on Wednesday 21st of November will be in Southampton.
Stop by the homepage of MrExcel.
There's still time to sign up for those. Would love to see you.
It's my first trip to do any excel seminars outside of the country, so it's kind of exciting.
Have an amazing trick today for charting and this is a trick that only works in excel 2003 and earlier.
They've actually taken this out of excel 2007.
It's kind of a wild trick although, It can really be a problem if you're not aware that it can happen.
I have a simple little data set here where I have numbers from January through June, and I've created a chart for that data set.
Sometimes if you're creating forecast numbers or something like that, it's interesting that you can actually allow people to change the numbers in the cells, by dragging points on the chart.
So the first time that I click on a point for example, this point.
I select the entire line.
But now a second single click, will select just that line and if we hover over that point, you'll notice that the mouse pointer changes to an up and down arrow.
And I'm going to move this up, but I want you to watch what happens to cell D2.
So it starts out at 16200 and as I drag the tooltip says that we go to 18600.
Sure enough when I let go it actually changes the underlying number in the cell.
I imagine this would be a cool way for someone to go through and set their, you know their budget expectations or something like that.
But just something to be aware of that it you could very easily, accidentally, click a cell and drag and actually change the numbers in the underlying spreadsheet.
Kind of an oddity, it was there.
I haven't seen many people take advantage of it and then now it's out of excel 2007.
So you know there might be some cool applications where you actually give someone, you know an executive system where they could just go through and drag numbers up and down on a chart and actually see the results of a calculation, only available through excel 2003.
Basically, it's one of those things that was not put back in excel during the rewrite of the chart in excel 2007.
Hey thanks for stopping by. We'll see you next time for another netcast from MrExcel.
I'm Bill Jelen.
Hey, just a quick reminder.
If you happen to be in England, I have two dates coming up. Monday, 19th November, I'll be in Manchester, and then on Wednesday 21st of November will be in Southampton.
Stop by the homepage of MrExcel.
There's still time to sign up for those. Would love to see you.
It's my first trip to do any excel seminars outside of the country, so it's kind of exciting.
Have an amazing trick today for charting and this is a trick that only works in excel 2003 and earlier.
They've actually taken this out of excel 2007.
It's kind of a wild trick although, It can really be a problem if you're not aware that it can happen.
I have a simple little data set here where I have numbers from January through June, and I've created a chart for that data set.
Sometimes if you're creating forecast numbers or something like that, it's interesting that you can actually allow people to change the numbers in the cells, by dragging points on the chart.
So the first time that I click on a point for example, this point.
I select the entire line.
But now a second single click, will select just that line and if we hover over that point, you'll notice that the mouse pointer changes to an up and down arrow.
And I'm going to move this up, but I want you to watch what happens to cell D2.
So it starts out at 16200 and as I drag the tooltip says that we go to 18600.
Sure enough when I let go it actually changes the underlying number in the cell.
I imagine this would be a cool way for someone to go through and set their, you know their budget expectations or something like that.
But just something to be aware of that it you could very easily, accidentally, click a cell and drag and actually change the numbers in the underlying spreadsheet.
Kind of an oddity, it was there.
I haven't seen many people take advantage of it and then now it's out of excel 2007.
So you know there might be some cool applications where you actually give someone, you know an executive system where they could just go through and drag numbers up and down on a chart and actually see the results of a calculation, only available through excel 2003.
Basically, it's one of those things that was not put back in excel during the rewrite of the chart in excel 2007.
Hey thanks for stopping by. We'll see you next time for another netcast from MrExcel.
