I've got a sheet that records a date/time and a value next to the time.I've got a xy scatter chart that plots the date/time the data was
entered (x values) against the value (y values). As I add new lines to
- Feb 22 Thu 2007 20:36
automatic series readjustment when Inew row added
- Feb 22 Thu 2007 20:36
Bar of Pie Chart
I have to pieces of data, Used and Didn't Used - For the Used the data is
broken down further. I want to use a Bar of Pie Chart, but don't know how to
- Feb 22 Thu 2007 20:36
Legend box position resetting when reopening file
I'm trying to get the legend to stay anchored above the chart by setting the
alignment to 'top', however whenever reopening the file, the legend falls to
- Feb 22 Thu 2007 20:36
Excel should highlight row/column location on mouseover
Location, for example E5, is highlighted for the selected cell. However, it
would be nice if mouseover did the same, maybe in a different color.
- Feb 22 Thu 2007 20:36
hiding columns or rows not using the hide function
I have come across spreadsheets that have a 1 or 2 in a box in the top left
corner of the sheet, and a plus or minus in a box above columns and rows that
- Feb 22 Thu 2007 20:36
merge contents in excel
Does anyone know how to take the contents of three columns in Excel and merge
them into a single column? Preferably adding characters if possible.
- Feb 22 Thu 2007 20:36
How do I add an extra line to a line-column chart?
Excel 2003.
I have 3 sets of numbers.
- Feb 22 Thu 2007 20:36
Rounding Up or down to 1/2 Units
Hi People,
Is there a way to round up or down in 1/2 units.
- Feb 22 Thu 2007 20:36
Formula to a number can you tell
In cell a1 I have a formula. At times whole numbers are entered in this cell
replacing the formula. In a seperate cell is it possible to distinguish if
- Feb 22 Thu 2007 20:36
vlookup must return a value that is greater than
If a value is not found in a range, I would like it to return the smallest
value greater than itself.A B C