I have a chart representing the following data:
1/17/09    $5,123.00
2/2/09    $125.00
3/30/09    $861.00

I know you can chart blank cells as spaces by clicking it in the
options...this is a little different.
The cell it is charting as an if function in it to display a blank cell.
example:

XL 2007, This should be a very simple chart but I'm getting extra data
points (dates) which are not in the data.  Dollars vertical, dates
horizontal.  There are 23 actual data points but the chart shows 30.  The
last date in the data is 6/15/2009 but the chart has 6/18, 6/20, ...

I have a scatter chart with dates on the x-axis and data on the y. When
trying to change the range of my x-axis, I right click on the x-axis, click
"format axis" and for "Minimum" and "Maximum" I click "Fixed" but it will
only let me enter dates in the number format (i.e. 39983 ...

It is too tedious to have to go in and manually type in the new cell
references to update charts weekly.  Is there a way to automate the process?  
If I could simply reference the new dates or something with maybe a macro
would help.  I am not conversant in Visual Basic, but an ...

XL2003
At work, we allocate a Labour Time for every job we have an order for.
I’m using a stacked column chart with 2 columns.
The first column shows the total number of hours for all jobs.

Hello, I want to have a linear time axis along the bottom of my chart, and
to display some values associated with a series of events and to have their
position on the axis grouped and spaced by the time that they occured.
This means that if I had three things happen at 9:15, 9:30 ...

Hi, all I am trying to get some data in a graph with a primary and secondary
axis. One side would be the Percentage complete the other would show the
times that the data was completed. I want to see the time and the percent on
teh Y axis. And just have one bar Like a thermometer ...

Ok, I need to add some cells together. They are numbered by buildings for the
cell and 2 buildings are in the same cell. How do I add them together, along
with the rest of the cells? ex: I did =J66+J66+J32
I need them to plus, plus, plus.. even though it's in the same cell.. does

I am conducting a risk analysis of a business.  I have identified controls
and i have calculated a "control score" for each.  The scores range from low
to moderate, high, severe, etc.  I currently have a grid in Excel which has
numbers that coincide with colors.  For example, the ...

Excel 2003
Hi,
I have set up an  employee table with around 1000 employees in a worksheet.
Each record consists of the following columns:

I have a bar chart with the following data
Depth (on left side axis of graph) - 50, 100, 150, 200 etc
No of blows (on bottom axis of graph) - 1, 2, 3....  10
I would like to add labels to the top axis of the chart, showing the

I have a simple column chart with a single data series. I would like to
change the color of an individual data point column depending on value.  
Thanks very much.

I have data arranged as Time of day in column B and multiple Y values as
columns D, F, and G
How do I get a multiple line chart with the multiple Y values plotted versus
the single column of time values in Column B?

I am using an XY (scatter) chart to plot eight time-stamped events (series).  
I want the Y-value for each event to be a constant so I can use different
colored error bars with different heights to show the event/series on my
chart.  Currently I have filled columns with the ...