Free Microsoft Excel 2013 Quick Reference

# How do I create a Graph using function/formula to get the values?

Situation: Student database, hundreds of names and other criteria.
Project: Create graphs/charts from data
Problem: can I/how do I use functions like COUNTIF to extrapolate the
values for the chart with out having to count them manually?
i.e. one colum has country of origin, in the worksheet I can
use
=COUNTIF(A2:A111,"Canadian") and get the total # of
id there a way to get the chart wizard to do this?
All help appreciated.

## Related Results

### How do I create a graph from an equation and not a set of data?

How do I create a graph from an equation and not a set of data?

### How do I make a graph using every 24 cells in Excel 2002?

I want to make a graph, but I have more than 256 cells. I can use values
acquired every minute instead of every 3 seconds. How can I make a graph
using every 24 cells?

Thanks.

### How do I create a Pie Chart from a LIST of Data?

I have a list of Data:

DATA
a
b
b
c
c

How do I create a chart from this data to show:
a 20%
b 40%
C 40%

Do I have to perform separate calculations, or is there a way this will just
work?
Thanks,
Jim

### Worksheet functions-How do I create a function that will add an amount according

How do I create a function that will add an amount according to the date?
Like a late fee?

### How do I create a bell graph for standard deviation?

I have 15 data points with a predetermined mean. How do I create a bell
graph to show the standard deviation lines and all of the data points along
the X axis?

### How do I create a formula that references a specific tab in Excel?

How do I create a formula that references a worksheet tab without using the
tab's name? I'm using the formula in a different file from the source data
I'm referencing. This source file will be written over constantly with a new
source file. The file name and path will always remain the same, and I
always want to reference the same worksheet tab and cell, but the worksheet
tab's name will change. In other words, I always want my file to reference
cell A2 in the 2nd tab from the left from the source file.

How do I create a sound alert, to use ,for when a cell value changes to a
given value. ie: I am importing realtime data and want a sound to notify when
when a certain value is detected

### How do I create a dynamic chart

I have a database on sheet "D" with 1000 rows of data 79 columns wide.

How do I create a single line chart on sheet "A" that graphs a single row on
sheet "D" where the row number is specified in cell H1 on sheet "A"

This doesn't work:

The chart would graph out whatever D! row number is pointed to by cell A1 on
sheet "A"

### How do I create a List in Excel 2000

In Excel 2003, I can create an Excel list by selecting the command "List"
under the "Data" menu. I do not find the same selection in Excel 2000. How
can I create a list using Excel 2000 as I use Excel 2000 at home.
When I open the list I created in Excel 2003 at work in Excel 2000, all the
list features disappear, all I can see a simple straightforward spreadsheet.
I wish I know how to create the list in Excel 2000 so that I can do
filtering, etc...

### How do I creat a math formula that remains in Excel.

How do I create a math formula that remains in excel? The formula allows
simple math calculations by clicking on an empty cell, the equal sign, the
populated cell, the math function you want to preform, number on the keyboard
and the answer will appear in the first cell clicked on. Trying to create
the formula in XP Office.

Thanks,
Jerry

### How do I create a macro of editing keystrokes?

I'm copying information from the Internet to paste into Excel, but the
information doesn't come in the format I want. In some cases I want to take
the last 8 characters, delete them from the current cell and paste them into
the next column. In other cases I want to add dashes, parentheses or spaces
between so many characters. Using the record macro button only copies the
data, not the keystrokes I want to repeat (e.g. in VB ActiveCell.FormulaR1C1
= "whateverIwant"). How do I create a macro that copies the keystrokes?

### How do i create a button to clear a value field i created?

i created a field in which you can enter values in different spaces and it
will calculate, these number accordingly.... how do i create a button to
clear the values inputed, so that the "calculator" can be used again

### How do I create a drop down list in Excel 2003

How do I create a drop down list in Excel 2003. I've tried to use the help
menu and I cannot figure it out.

### How do I create a macro of editing keystrokes?

I'm copying information from the Internet to paste into Excel, but the
information doesn't come in the format I want. In some cases I want to take
the last 8 characters, delete them from the current cell and paste them into
the next column. In other cases I want to add dashes, parentheses or spaces
between so many characters. Using the record macro button only copies the
data, not the keystrokes I want to repeat (e.g. in VB ActiveCell.FormulaR1C1
= "whateverIwant"). How do I create a macro that copies the keystrokes?

### How do I create a single template that will process multiple rows of data?

I want to do something that is easy to do in Microsoft Access, which I no longer have, but I don't know how to do it in
Excel.

I want to be able to take a rows of data and output them using a single template (not sure of the right word). E.g.: The
data in worksheet 1 is this:

A B C
1 Jim Hart 123 Main Street 123-4567

2 Joe Smith 456 State Street 234-5678

3 John Brown 789 Elm Street 345-6789

How do I create a single template in worksheet 2 that takes the above data and outputs the data arranged like a rolodex card
without having to write (or cut and paste) a template for each row individually? In other words, I just want to create a
single form that takes the data and that will then create as many rolodex cards as there are rows of data.

Thanks for any help.

### How do I create a List in Excel 2000

In Excel 2003, I can create an Excel list by selecting the command "List"
under the "Data" menu. I do not find the same selection in Excel 2000. How
can I create a list using Excel 2000 as I use Excel 2000 at home.
When I open the list I created in Excel 2003 at work in Excel 2000, all the
list features disappear, all I can see a simple straightforward spreadsheet.
I wish I know how to create the list in Excel 2000 so that I can do
filtering, etc...

### How do I create a new table below the last one

I've been having problem creating this macro
my problem is that i have 3 sheets and I've been doing the macro jumping
from one sheet to another and if I dont put my active cell in and expecify
place the macro won't run and if I dont use the relative reference the macro
will be repeat it in the same position on top of the one already create it ,
How Do I create a macro that when i make the sheet in the first sheet
simultaniously create the other tables to in the other worksheets.

ActiveCell.Offset(-38, 0).Range("A1").Select
ActiveCell.Range("A1:O38").Select
Selection.Copy
ActiveCell.Offset(38, 0).Range("A1").Select
ActiveSheet.Paste
ActiveCell.Offset(38, 0).Range("A1").Select
Sheets("T+M").Select
ActiveCell.Offset(-100, -8).Range("A1").Select
ActiveCell.Range("A1:W89").Select
Selection.Copy
ActiveSheet.Shapes("Object 29").Select
ActiveCell.Offset(89, 0).Range("A1").Select
ActiveSheet.Paste
ActiveCell.Offset(89, 0).Range("A1").Select
Sheets("Murk 12C").Select
ActiveCell.Offset(-43, -8).Range("A1").Select
ActiveCell.Range("A1:Q32").Select
Selection.Copy
ActiveCell.Offset(41, 0).Range("A1").Select
ActiveSheet.Paste
ActiveCell.Offset(41, 0).Range("A1").Select
Sheets("MURK 11A").Select
ActiveCell.Select
End Sub

### How do I export a graph as a gif file (Microsoft Excel 2000)

How do I export a graph as a gif image.

I am using Microsoft Excel 2000 (Office Professional and ALL components are
installed)

### How do I create a chart where there are two Y axis and the bars ar

How do I create a chart where there are two Y axis and the bars are side by
side. I created one and used overlapping, but it puts the bars on top of
each other as opposed to side by side...

### How do I create a pivot table from multiple pages of data?

I have data in a spreadsheet in excess of 65536 lines so I have the data on
more than one page in a workbook. How do I create a pivot table that will
use more than one page of data to create the pivot table? Is it possible?

### How do I create a dynamic chart

I have a database on sheet "D" with 1000 rows of data 79 columns wide.

How do I create a single line chart on sheet "A" that graphs a single row on
sheet "D" where the row number is specified in cell H1 on sheet "A"

This doesn't work:

The chart would graph out whatever D! row number is pointed to by cell A1 on
sheet "A"

### How Do I create a clickable Timestamp button

I love Excel...

I have all kinds of timestamps in my workbooks using VB editor, but they all require you to enter a character into the cell in order to show the timestamp. The one thing I cannot seem to find anywhere is how do I create a time stamp that is activated by merely clicking a button. Lets say I create a hyperlink button that you click and the next cell over shows the timestamp. Even if its just a cell that you click, (i.e., click any cell in column A and the same row in column B will show the timestamp

Thanks for the help
RC

### VBA: How do I create a level 3 Menu in the Excel toolbar ?

Hi,

I would like to save my all assigned macros in a New Menu in an Excel toolbar. In stead of saving the macros
under Level 1 menu, I would like to save them under a Level 3 menu.

How do I create a level 3 Menu in the toolbar ?

Appreciate any help on this matter.