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

software 發表在 痞客邦 留言(0) 人氣()

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

software 發表在 痞客邦 留言(0) 人氣()

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

software 發表在 痞客邦 留言(0) 人氣()

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.

software 發表在 痞客邦 留言(0) 人氣()

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

software 發表在 痞客邦 留言(0) 人氣()

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.

software 發表在 痞客邦 留言(0) 人氣()

Excel 2003.
I have 3 sets of numbers.

software 發表在 痞客邦 留言(0) 人氣()

Hi People,
Is there a way to round up or down in 1/2 units.

software 發表在 痞客邦 留言(0) 人氣()

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

software 發表在 痞客邦 留言(0) 人氣()

If a value is not found in a range, I would like it to return the smallest
value greater than itself.A B C

software 發表在 痞客邦 留言(0) 人氣()