I would like to automatically change the color of a bar depending on the
entered value versus a targeted number.  For example:  The target value is
50, if the entered value is 40 (below target) the bar on the graph shows up
red.  If the entered number is 60 (above target) the bar ...

My graph with two series does not match?? Any suggestions.  How can u
match a series to the x axis - is there any way to manipulate the chart
without changing the data??? Thanks - Matt

I presently have an XY line chart showing asset price over time. Pretty
simple.
X Axis - Time Scale
Y Axis - Asset Price

Microsoft Excel 2002
I have 155 clients which I need to run Pivot Tables for! All with the same
pivot table layout.
Is it possible to run the Pivot table with the 155 clients as a Template

Hi, I have a VBA function like so:
Code:
--------------------
 Private Sub AddSeries(ByVal strName As String, ByVal rngValues As Range, ByVal rngValuesX As Range, ByVal xlAxis As XlAxisGroup)

I need to plot ternary diagrams, does anyone know of a addin? I have been
trying the addin of Julien Furrer "Trixcel". Two problems, instructions are
in French and it crashes alot with larger datasets.
I need other suggestions please, thanks,

I am trying to put January thru June data in a line graph (no problem) but
the boss now wants to see the current month, by week, on the same chart.
Is this possible?
Any help would be greatly appreciated.

How can I save a chart in a worksheet as a gif which I can later use in a
web page?
                      Thanks, CMA

I am creating a chart, and sometimes the data will exist such that there are
points that I would like ignored.  These points are determined by an If
statement, so I can place any string in there when I want them ignored, but I
have not been able to find a string that will result ...

Are there any add-ins available to make waterfall charts?
Thanks!

I want to display sales data in or on a geographical map of North America.
Can anyone advise how i find a chart type that displays data in a map so that
I can  represent sales data in cities and provinces / states?

I am trying to make a control chart (of sorts) following the procedures shown
here:
http://www.peltiertech.com/Excel/Charts/ColoredQuadrantBackground.html
I have RED, YELLOW, GREEN, YELLOW and RED bars and I've gotten them to show

I want to chart the difference between 2 sets of data "on-the-fly" without
having to add a difference column in the raw data.  Can you put formulas in
the series box of the chart wizard?

I posted in PPT group but would like to try here as well.
Im trying to automatically update a Excel OLE CHART object Data in a
Powerpoint slide.
The name of the chart object in PPT slide is "NRMAWC023". It has an excel

My first post. I have data for residents of the care home that I work
at. One example is their monthly weights. I presently have the data in
the following form:
jan   feb   mar   apr   may