I'm am trying the create a stacked bar chart can't seem to
get it to work. any suggestions appreciated. here is an
example of my data. I will have multiple causekeys for
each causecode.

i'm trying to build a chart that will display actuals (columns) and
forecasts (which is a horizontal line about the same width as the column
within the column)
x-axis - product a, product b, product c

How do I change the X-axis interval in a line graph? For
example:
I have the number set: 0, 0.5, 1, 2, 4, and 8 for my X-
axis. By default, Excel makes the interval for 0 and 0.5

Howdy all,
I am creating Normal Probability plots to test normality assumptions and
compare variances of two independent datasets. If the plotted data
approximate a straight (diagonal) line, the data can be assumed to be

does anyone know who to create bar charts where data is spaced on
x-axis?  currently i have time data on x-axis and quantity on the y.
but the time data is evenly spaced rather than by the amount of time
that has passed.  in other words, i want events which occured 1 hour, 3

I have a chart with 2 Y axes. One plots 3 lines and the other two.
I managed to place several horizontal lines using the method Jon
Peltier describes in his great site.
Now I need to do something pretty classic: have vertical lines in each

I'm trying to create a scattergraph in Excel 97.
I have the data (the results of tests) in 2 columns. For example:
A            B
     29.5

I know how to format data labels one at a time, but what
if I want all the data labels in a chart to have the same
formatting? Is there an quick way to do this w/o having to
click on each one?

The bubble size in bubble chart is adjusted automatically
by EXCEL so as to achieve best visualization result. But
when you want to see the bubble changing size, this
adjustment is bugging. For example I wrote VB code to

Thanks to Tushar Mehta, I was able to add multiple line
graphs within the same graph.  But, now, can I rename
the "series" to the actual dates?  In other words, Excel
automatically names each line "Series 1, Series 2, Series

I am using VB to create a chart with log base 10 axis with a range of
0.1 to 100000.  The major ticks are labelled with the number value.
However, I need a scientific-quality chart that uses "10 to the power
of x" notation with x being a superscript.  Excel's option of using

I'm somewhat new to VB and Excel automation, so I am probably doing
something stupid.  I'm generating bar charts, saving them as GIF
files.  The vb macro always dies with errors after around 5500 graphs,
sometimes leaving a Chart5500 worksheet open in the spreadsheet.

i am trying to figure out a way to plot one cell, lets say c-1 from 10
-30 worksheets, in one workbook; on one chart. Each worksheet is a date
and each c-1 value is just a number.
any help would help

I am very new to Excel, but I do pick up things pretty
quick. I have started a chart with a list of my customers
and it is working out really good. My question is I need
to add another name/line in between the others. Meaning I

I'm trying to set up a pie in pie chart and I'm not sure
what I'm doing wrong.  I have 3 data points for the main
pie and 5 data points for the secondary pie.  Both sets
total 100%, but what is happening is that in the main pie