Mr Excel & excelisfun Trick 16: Scroll Bar For Percentage

[onibenz]

THANK YOU SO MUCH!!! This helped me a lot =D

[Cnewr]

Hi, I think your podcasts are fantastic! (helps me out a lot - I'm from New Zealand). I was wondering if you had a video on ActiveX Controls, more controls and then inserting Windows Media Player for example? I'm just curious to know what these controls are for and how to use them.

[ExcelIsFun]

The only other video I have is this video title:

YTL Excel #118: Form Controls Linked To Cells

[ExcelIsFun]

Or this one too:

YTLE#110: Excel Forms Scroll Bar Linked To Cell

[crunch831]

i have a math question im taking intergrated algebra, ok so heres the question

Using the frequency distrubtion table,determine in which the interval the 40th percentile falls.

ok im confused so how do u find the interval of the 40th percentile

[nicksanmat]

I mean, we can see you on the video, what do you do to do that?

[ExcelIsFun]

Dear nicksanmat,

I use the program "Camtasia" with a web cam.

--excelisfun

[nicksanmat]

how do you put that camera on the screen without closing excel??

[ExcelIsFun]

Dear nicksanmat,

I do not understand your question.

--excelisfun

[sammyjny]

@ExcelIsFun LOL



[LeeJackson01]

Really cool stuff in that vid - but not really what I was hoping for.

I had heard of another way to show a rolling 9-week (or 13-month) snapshot of data within the chart and the chart would automatically update as the data approached the end of the week.

Thanx anyway though.

Take care.

[ExcelIsFun]

Dear LeeJackson01,

Send me emial to my excelisfun gmail account and I will send an example of what you want!

--excelisfun

[LeeJackson01]

Awesome!! Love it!

Hey -- Can I request a future lesson? I'd love to be able to have my bar-graph automatically show only the last 8(+1) weeks of data (the extra week is a week to the right - future week - for visual asthetics). Currently ,each week, I need to change the range of the view manually. I had heard there's an automatic way of doing it.

Possible?

Thanx again. Y'all rock!!

[ExcelIsFun]

Dear LeeJackson01,

I already have a video on this topic. Try this and see if it works:

Excel Magic Trick # 262: Dynamic Weekly Chart

--excelisfun

[ShunmasBeeablo]

Yes Mike, i asked the same question in mrexcel message board but ....no solid response...anyways, great vid...cheerz

[ExcelIsFun]

Dear ShunmasBeeablo ,

I am glad that you like it!

--excelisfun