I am using a standard stacked column chart. Unfortunately there are series
in the column that are not showing in the legend.
This might have something to do with the fact that some rows are cut into
and out of the charted data.

I am tracking the percent of sales by product catagory for a company.  They
have low percents for everything but one area.  I mean, most product areas
are less than 10% while one is 60%.  I want to remove the distance between
the 60% product catagory and all the others but still ...

I'm trying to shade an area on my scatter graph and it's all going very
wrong!
There is a diagonal line on this chart and I simply want to shade in
the area beneath it.  But when I change it to an Area Chart it goes all

I have a spreadsheet linked to an access database. The spreadsheet refreshes
every 60 seconds automatically. I want to track current performance by using
a chart that shows the last 25 data points entered.
It is impractical to manually change the chart range each time a data entry ...

I have organized the data in a table that has in the first column the years,
in the first row the periods and in the other cells the respective sales.
Problem: when I select the entire table and use the Wizard to create a bar
cart, the first column is treated as the others ...

I am graphing my son's date-weight graphic. But our weighting dates are
irregular. When I graph those datas, between dates in x-axis become equal.
But I want excel understand they are dates and scale like dates. For example
2 days between two date is same space as 2 months. I ...

I would like to get the average curve from several curves on a plot. Is
there a way to do this in Excel?
(Background infromation: I have, say, 10 sets of XY points and I want
to take the average of these to obtain a set of average X and Y points

I have complex charts, with many data points.  The redraw time on my machine
in Excel 2003 (all updates for office and wxp installed) is 2-3 sec, which I
consider extremely slow, so I was looking forward to an new chart engine with
better speed from 2007, but am flabergasted at ...

Is there a way to show multiple values in a single bar (in a bar graph) that
add up to a total (example: 127, 129, 87, 85, 60, 126, 89 add up to 703)? I
want a sigle bar that goes to 703 but breaks the single bar down into these
segments (preferrably by color showing the smaller ...

Re-posting from
  http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=526051&SiteID=1
Thanks
Darryn

Yesterday duncanslam (Steve Duncan) posted in Excel.misc for a way to
hide charts that don't have data. Seemed doable to me, so I had a go
only to discover the nasty problems associated with returning the
address of a chart's data.

I want to transfer some charts (as picture) in excel to a particular
word document (specific page and specific position). The word document
already has some data and lots of pages in it and Im inserting charts
in specific places.

is there option to set conditional formats on charts ?
like change the color of a column with certain value

I am constructing graphs from an Excel pivot chart for use in a Wordreport.  
When I paste the graph (using paste special, enchanced metafile) I get the
graph in Word in grey tones only.

Hi all - If someone can help me here I would be most grateful. I have a
chart which plots values over a time period of say 15 years. The value
is entered in one cell and then a macro is run to generate the returns
for each of the 15 years which the chart then plots.