I'm new to graphs and what I have is a date range (1-Jan-08 - 31-Jan-08)
with a dollor amount in the next cell. The bar graph is picking up the "zero"
or blank ("")cells and is ploting them on the graph. How can I have the graph
not plot the "zero" or blank ("") values?

I was wondering if someone could give me an example to help me get my
head around the best way to do this.
I have posted before on how my charts us data tables and that I would
like to change that.  I need to add annotations to specific months

Hi.  I have a spreadsheet that has several hundred embedded charts.  The data
is updated monthly and the charts automatically update themselves.  The
problem is that when the data is updated on the charts, the plot area reverts
to some default size which does not take advantage ...

I have a chart with a chart title. I would also like to have a title box
above the legend. Is it possible to create another title so I can place it
over the legend?
The way I see it, there can only be one title. Is there a way to insert a

I wanted to have the tick on the x-axis right over the label so I lurked from
another post (Andy) the following:
"Double click the category axis and on the scale tab uncheck,
Value (Y) axis crosses between categories.

Can anyone please tell me how to put the company logo under the chart, on the
chart page, tried many times but  do not seem to beable to get it to go below
the chart, I'm using office 2007,
Thanks

I would like to plot a bar chart with 2 bars, eg. bar A & B.  I would like
to have the graph display as Bar B over Bar A, how can I do that?
Please kindly advise.
Thanks alot.

I am plotting Target vs Actual completion dates for a project management
S-Curve, using Excel. Since both data columns are "dates", Excel wants to use
"dates" on the Value Axis (Y), while putting the Task #s on the X axis. How
do I switch axis' so that time runs horizontally on ...

In a thread on 1/4/08 someone asked about how to do multiple pie charts in
Excel (my version: excel 2002).  There was a discussion of why one would not
want to use multiple pie charts. I saw no advice on how to accomplish the
task if one wanted to buck convention.

I'm working on an app which i need to copy a range of cells which is
programatically generated using the Excel object model. I want to be able to
select the output range which consists of charts and cells making up a table.
I'm using the CopyPicture() method of Range which i had ...

I would like to know if it is possible to have two different colors in the
plotted area of an area chart.  In the end, I would like to have the color
for numbers less than 0 be one color and greater than 0 be second color.  
Thanks

Hopefully someone can shed some light on how best to do this. I'm working
with the Excel object model and want to specify a data range which consists
of non contiguous columns in the dataset. I cannot seem to find a way to do
this and then set the data range to the data source of ...

Trying to graphically prove whether my son is worthy of a car.
I have a spreadsheet with this header row:
Date    Time Promise    Actual time    Commitment    Actual Commitment    Task/Help    Actual
Task/Help    Plus/Minus

Hi, I'm working with Excel 2007, and I am pretty happy with the antialiased
lines in the charts. However, the text for the axes and the axis titles is
not anti aliased. I must be missing something, because i can't believe they
wouldn't include this after antialiasing the charts. ...

I have named ranges on sheet1 to create my chart.
ChartDates for the X axis
Data1 for the values
I then entered