Jo Said:

Can you help me with this formula?

We Answered:

NO! you have to replace V2 with given volumes:
P = (V1P1)/V2
P = (4 x 1)/3
P = 4/3

Now do the same thing for V2= 2. V2= 1 , V2= 5 and V2= 25

Lonnie Said:

Help in creating Excel template that graphs data with variable # of rows?

We Answered:

It sounds like you need a macro for that. If there is no data in Column C the Macro is pretty simple.

First, go to:

View > Toolbars

Then select the control toolbox toolbar to make sure it is visible. After you do that, select the command button on the toolbar and create a command button.

Now right-click on the new command button and select View Code. From where your cursor is located enter the following:

ActiveWorksheet.Range("A1").Activate
ActiveCell.CurrentRegion.Select

Close that window and go back to your regular Excle page. Right click the command button again, but this time select Properties. Change the property for Caption from CommandButton1 or whatever the name of the command button is to whatever you want the command button's text to display. While you're at it change the PrintObject property's value to False. Changing the PrintObject property to False causes the command button not to be printed if you want to print the data on that page without seeing the command button. DO NOT change the Name property at the top of the list. If you do the macro you just wrote won't work. After changing the Caption property, close the Properties window.

Now move and size your command button how you want it. When you have it the way you want it as far as placement and size make sure it is selected and click the button that looks like a drafting triangle on the control toolbox toolbar. This makes the command button active and ready to run.

As long as Column C is left completely blank and as long as you put the command button on the worksheet you want to select the data from, clicking the button will select everything from A1 to the end of your data automatically no matter the length of your data.

Penny Said:

How do you find an average of just one number? Round? and what if they're in decimal form?

We Answered:

Mathematically, the average of just one number is the number itself.
Conceptually, the average of one number doesn't really make sense. If you find yourself seeking the average of just one number, it's a safe bet you've got the problem wrong.

??

Erin Said:

Using excel how can I make a scroll button to view months of another worksheet and view it in a chart form.?

We Answered:

Difficult to say with certainty since we only have your description of something you saw. However, I have seen something similar myself and that's because I did it myself ;-)

I have a workbook with three graphs appearing in a single sheet that you can scroll through. The data is pulled from other sheets so all the viewer sees are the graphs. You can also move your graph image on top of data too. It gives a similar look.

However, not done yet! I also turned off the gridlines and changed view to page break view. I removed all the page breaks. All this makes it seem even less like a worksheet and more like just a view of graphs.

Hope this helps. I can send you a sample if you need a demonstration of the method in visual form. Just send me your email address and a link to this question.

Kind Regards,
QwertyKPH @ Yahoo!

Jacob Said:

Is a dedicated graphics card necessary if the laptop comes with 6GB RAM?

We Answered:

RAM is the memory of your computer. A graphics card can have its own RAM or share the RAM of your computer. A graphics card however is more than RAM alone, it is a physical device, it is hardware. Two graphics cards with the same amount of RAM do not mean that they perform the same. Integrated graphics cards are intended for office work, browsing the internet, watching a movie, et cetera. They are not intended for playing computer games for example, the hardware is simply not designed for that and does not meet the minimum hardware requirements that most computer games have. Even if you would assign 1GB of your computer RAM to your graphics card to use, it does not improve the hardware the integrated graphics card consists of. Dedicated graphics cards are more intended for playing computer games, but once again there are differences between the hardware of the different dedicated graphics cards. Comparing two dedicated graphics cards with 1GB of RAM for example, one will perform better than the other, as the hardware of one might be better than the other. I hope this clears things up a bit for you. As for how logical it is how HP builds their computers, the second laptop which you mention has indeed less RAM and does not have a Blu-Ray player, but it does have a better processor and graphics card. If the second laptop would contain the best of both laptop number one and number two, it would be even more expensive and people would not purchase it. It is always a matter of price and what you get for it. People want to get a lot, but only want to pay a little, so HP has to create laptops which appeal to the general public. As for your last question if you would notice any difference between these two with the tasks you mention, no, you would not notice any difference. Both laptops would be overkill for such tasks even.

Eva Said:

Excel Charts not sizing correctly?

We Answered:

Can you create the graph in a different worksheet; or save it as PDF? Look at it in Print preview, perhaps the margins need adjusting.

Jill Said:

Excel 2007 help - why did I just lose all my charts and text boxes?

We Answered:

Did you look at TOOLS>OPTIONS>VIEW and see if "Hide All" is selected?

"Show All" should be selected