I need to build a chart that has data sources on multiple spreadsheets in the
same workbook but can not make it happen.  Can anyone provide advice on how
to do this.  Sheet 1 contains q1-Q4 data for 2003, sheet 2 contains q1-q4 for
2004 etc.

I working with 2 axes line chart.  My x-axis is month/year and my first y
axis is instrument result for Hospital A, my second y axis is outside
temperature.  The chart looks great.  Now I want to add addional lines for
other hospitals.  When I click on add series and add the data ...

I have a stacked bar chart with three series, and I'd like to connect
categories across all three series using series lines. One of the
series has an empty category, which I'm placing as the last (top) item
on each stacked bar.

    have a curious problem when setting the formula on a series via code
(C#)
   When setting the formula property like this
currentSeries.Formula="SERIES(\"TradeTranche1\",Node!$B$10:$B$70,(Node!$DC$10:$DC$70),1)"

Is there a way to have excel not graph a space in between dates that are not
right in a row... for example.  if I have 12-1, 12-2, 12-3, and then jump to
12-6.... how can I avoid that space in my graph.
also... I find excel graph's to be difficult to work with... are there any

Is there any way to avoid the following:
When I add a series to a line graph which has an appropriate scale for the y
axis, the scale changes as soon as I click on 'Add Series'.  The Values box
populates with ={1} which forces the minimum value on the y axis down to

Can time be used as both the x variable and the y variable when
creating a scatter plot?
I want to determine the correlation between the time a company TV
commercial is aired versus the time of day that we receive phone calls.

Can time be used as both the x variable and the y variable when
creating a scatter plot?
I want to determine the correlation between the time one of our company
TV commercials is aired versus the time of day that we receive phone

If the maximum of one data point is much greater than that of all the other
data points, is is possible to split the scale on the Y axis, so I can
enlarge the lower data points and still show the max of the largest data?

Microsoft Excel 2002 SP3.
I have data that looks like this:
    Median    Min    Max
Na    0.032617    0.000106    0.387142

Does the charts have to be on the same worksheet as the data when creating
dynamic charts?

Hi Folks - I have some totals in this format:
Unit               Count     Sum
Marketing        25           300
Accounting       40           400

I have a chart that uses input from several departments. I would like to have
the chart title change depending on the data used.
using excel 2002 sp3

I'm looking to create a graph chart with 3 series as bar charts,
accumulated/stacked on the first Y axis, and teh fourth series as a line on
the secondary y axis. i have tried to use the custom chart with lines7
colummn on two axes, but thuis does not allow to show bars as ...

I have one doubt in bar chart. I have created one bar chart.
That contains 4 serious collection. All 4 bar shows well. But if i
delete the one or two serious collection, Bar size is increased. Bar
shows bigger size. I need the same size even if i delete the serious