Whenever I use a series of date ranges in a chart the display on the axis
becomes a series of numbers (IE 1,2,3,4.....) rather than the
dates(01/01/2004, 02/01/2004,03/01/2004......).
Very frustrating...not sure why.

I am trying to produce a chart with the following data:
x-axis      Y-Value     Volume
10    1.95%    717
11    1.93%    519

Howdy,
I'm plotting a series of xy points on an XY Chart.  I've
also added a '1:1' trend line to the plot as a second
series with the markers turned off and 'line' turned on.

I have a workbook containing cost data for up to 20 client
plans.  Each plan's data generates three different graphs,
which are collected on three separate worksheets.  Thus,
sheet 1= 20 plans worth of data input, sheet 2= 20 graphs

I have tried to use 2 axis within a pivot report however you are unable to
say use a scatter graph? I have 2 sets of results against row. Some of these
results are positive some negative I need to see all positive in the centre
of the graph. Then moving out to the either end of ...

Why does only the bottom row of cones in the custom cone chart appear as 3-D?
All the other rows of data appear as 2-D circles. Is there any way to fix
this?

Does somebody know how I can combine a clustered and a stacked column in Excel?

Now I know the white space can be removed by draging plot area but without
changing the size of plot I like to remove the white space. Is that
impossible ?

Hello, first Post - so here goes....
I am ploting a simple chart in Excel - when the value of a cell, say F5, is
zero (calculated as =F4/F3) or F4 and F3 are zero and F5 returns #DIV/0! - I
don't want to plot that cell at all.

I guess i'm having more problems than not.
I've been trying to use autofilter and using xy charts.
I have a series of information which can be grouped into differen
events.  I'm using autofilter to help me sort the data.  When graphin

Hi. My question deals with creating bubble charts and dynamically addin
series.  I have data in the Following Format
Col A:  Series Name
Col B:  X Value

hi, just wondering if anyone knows how to alter the values
at the bottom of a line chart? i have a set of data and
need to start the set of data from 16-30 without much
luck! as opposed from 1 -15! anyone help??

Greetings, all -
Just thought I'd post a solution I devised for plotting a trendline for
multiple series in an XY scatter chart. I wanted to group my data into
different series based on category (Very Good, Good, Fair, Poor, and

I am having trouble with creating a particular column
chart.  I would like to plot several independent variables
with some using the primary y axis and some the secondary
y axis.  

i am makign an histogram chart. teh x axis has values from
0-70 and y axis has values from 1-31 (why its starting
from 1 i am unable to make out) the range shoudl ideally
start from 0.