I am using an XY scatter chart to plot Absorbance readings vs. Concentration.
What I would like to do is plug in and unknown absorbance and it return a
concentration read from the chart.  Any suggestions?

I have a worksheet for each month within a file - each worksheet has data
tables, and some charts generated from that data. With Excel 2003, when I
copied a worksheet within the same file (for example, to create the July
sheet, by copying the June sheet) the charts in the new ...

How do you create a column chart with a secondary axis without having the
bars overplotting?  I would like the bars to be adjacent to one another.

Charts made in Excel 2007 change format when put into Word and are saved so
that compatible with earlier versions

I have a bar chart that has a significant amount of whitespace in the
chart area that I can't seem to get the chart to fill up. I have tried
extending the area to fit the plot area, but that only made it bigger.
Does anyone know who to get their charts to actually fill up the plot

How do I place an arrow running West>East with an X symbol? (I only found
labelling
an axis with words).

I have a little problem with some code I've been using. In my workbook I have
7 sheets with 45+ pre-made charts. Some have data but most don't. The current
code I have counts how many charts there are on the sheet, selects,
activates, and prints them all the way I like. Thing is ...

I have a chart that I use to plot a number of diffferent data series.
Sometimes the numbers I am plotting are small e.g., within the range 0 to 100
and it looks good because the display (y axis) looks
0,10,20,30,40,50,60,70,80,90,100. Sometimes however the data I plot is large

I've created a pie chart that shows the Category name in the default location
(outside of the pie chart itself).  That's the easy part.
I need to show the Value but do not want that Value to appear after the
Category name.  

I have four data series I would like to visualize using a bubble chart.
(x, y, r, p)
x: x axis position
y: y axis position

I have a chart that plots body mass index, ie value on y axis, and dates on x
axis.  I have also added a second category x as I have divided the chart into
horizonatl zones with different colors (ie underweight, overweight etc).  
Things work fine except that when I plot, for ...

Is there any way that one can change the color of a line in the chart
depending on the value of  some other cell in the spreadsheet e.g., if a
certain condition is true, the line (or point on the line) is blue and if it
is false the line (or point on the line) is red.

I've upgraded to Office 2007 and opened an Excel workbook from Excel 2000
which contained a number of graphs both on sheets and on tabs of their own.  
One graph is fine but the others are screwed up because of the way it is
treating empty cells or gaps in the data.

How do i "unlock" the Amortization Schedule so that I can add columns for
aditional data

I am attempting to add a vertical line to a dynamic column chart. I've
followed the steps described by Jon Peltier at
http://peltiertech.com/Excel/Charts/AddLineVertSeries.html
This procedure works fine until I change the base unit on the x-axis to