Excel Tips
Paste Special
- If you copy cells (or a column) in Excel, and they have formulas, you
will not get what you want
- Use the "Paste special", and then pick "Values". The cells or
column will just have the values.
Very Quick graphs
- Copy the data into adjacent columns, with X in the left column, and one
or more Y's in the right columns. Use "Paste Special" if there are
formulas (even if not, to be safe)
- Highlight the columns
- Pick the Graph button, and pick an XY graph.
- Accept all other settings, except maybe to to put the graph into a
separate page.
- You will have a quick and dirty graph, which you can edit if desired by
right clicking.
Put Y Axis labels on the left
- Right click on the graph.
- Pick click on the x Axis (the one that is not giving you problems)
- Uncheck the Value (Y) axis crosses at
- Enter the value you want, which should be the minimum
- You can do a similar thing when the x axis is labeled at y=0, which is
not the bottom of the graph.
Copy a graph (say to make a blowup of part,
keeping the original)
- Right click on the tab for the graph (if you graph is not on a tab,
right click on it, and change the location to a tab)
- Pick "move or copy"
- Check the "Create a copy" box
- Pick the location if you want (move to end at the bottom of the list is
good)
- Pick OK
last revision 1/21/2010