Search results

Dear VBA Gurus Years ago I saw a post on this forum wherein if you click within a particular range of cells, the value in the selected cell is produced in a destination cell. For that I used following code: >>> use code - tags <<< Private Sub Macro1() If Not...

Dear Excel Gurus!! I need help relating to bar charts color. The situation is as follows: I have a daily sales bar chart for 6 months. On x-axis are days - Jan 1 to 31, Feb 1-28, Mar 1-31 and so on for six months. Y-axis represents sales data. Now All I need is to click/select/highlight...

Hi everyone! I am looking for some excel stuff that could help my kids practicing basic mathemarics. My kid is in grade 5 and would need practice for multiplication, additions, substraction, division, mental maths etc. Can someone help me knowing if there's something available like that?

Morning all! I need to draw "growth indicators" in excel charts but somehow I couldnt figure out how to do it. Just to clarify my problem, currently I am using "think-cell" application to create charts in powerpoint that are linked with excel. These charts are convenient but do not give much...

Hi everyone. can I arrange all items on x-axis in a chart in ascending order based on values on y-axis? Actually i have a data matrix having various columns of data categories for respective variable in rows. Therefore i cannot sort a particular column in my data series. Instead I want excel...

While doing my routine work on excel, my fav formatting style is that first i fill entire sheet with lightest grey shade, then I draw borders of cells in 3D style. For example for upper and left border I select dark grey color and white for lower and right border. Thats how I get an ENGRAVED 3D...

Hi every one. I need to know if it is possible somehow that we could insert comments in a graph which are not visible unless we point a particular bar with the cursor. The concept is same like inserting comments in excel cells. I do need it to describe events underlying fluctuating bars of a...

I am a non-IT person (cannot work on VBA etc.) and using excel for quite some time. I regularly use Form Controls and by now I am really tired looking at these old fashioned controls. Can someone please help me knowing how can I get more beautiful and sort of stylish form controls? I would love...