howdy,
I'm trying to setup a chart in excel that conditionally formats the
background colour.
I'm already using the speedometer chart

I could have sworn that a long time ago, I set up one or more text boxes on
a graph that had formulas in them, so the text that was showing would
automatically change each month.
I'm now using Win2000/XL2003, and not having much luck- I want to put my

Excel 2002(XP)sp3 running on XP Pro.
Chart wizard appears to work until rendering the chart on the sheet.
The resulting chart is drawn incorrectly.  Line and Bar render only a
thin vertical line without any data.  Preview mode during the chart

Hmmm...
This is a challenge to put into words, but here goes.
I have to make a simple bar graph showing sales results from our ten clients.
All I want for each client is a bar with what we budgeted their sales would

I have made some charts with the data populating the underlying tables using
Vlookups.  However as they are populated over time i dont want to show any
null values.  I have tried the following formula =IF(D14=0,"",D14) to convert
the 0 values in to a null value but it still shows ...

I have the following question:
I have an Excel chart with a target line. In some cases I want to have the
target line as a dotted line, and sometines as a continuous line. Somewhere
on the worksheet is a cell wich determines if it must be a dotted or

I am creating Pivot Tables in Excel and at the bottom of the pivot table, it
will show the total for each column. When I create a Pivot Chart, these
values are lost. I would like to show them somewhere on the pivot chart.

ok I have a workbook with sheets named by month (Sep, Oct, Nov...) I have a
sheet named Weekly.  In Weekly I have a LOOKUP function as such.
=LOOKUP(B1,Oct!$B$4:$B$34,Oct!$E$4:$E$34)
B1 = Date in Weekly to lookup.

Ok, I am doing a chart with two X axis' and two Y axis. The X axis' are years
(from 1970-now) and the other X axis is the US Administrations for these
years. Now what I want to do is have vertical gridlines coming down at the
start of each administration (obviously different ...

hi, bascially i jsut need to knwo how to do what my question says. i am
familiar with most things in excel but have never been able to do this and
jsut wondered if it was possible and how to do it basically.
Thankyou In Advance For All Your Help

I need help asap

I have created a chart that plots visitors to a site over a period of
time. Now the chart has the dates on X axis and the data is plotted
along Y axis (0 to 5000).
How do I lay the chart so that the date is on the Y axis and the 0 to

I have created a bar chart with 4 colums of information. I would lik
two of the columns to be behind the other two colums. Can anyone hel
me with how to do this.
I have tried creating the chart then offsetting but obviously all th

I have two pieces of information per day I want to show on the below
graph.
How do I create the graph below? So just the red is changing?
I have tried the usual ones on Excel but non of them do what I want.

How can I create a chart based on a 2 dimensional range of data, which is
dynamical in one direction?
Problem: set of data in rows.
A named (dynamic) label range: “wk2005”=offset($E$2,0,0,1,counta($2:$2)-2).