I am trying to build a standard sheet with a chart.  This chart may contain
28, 29, 30 or 31 rows depending upon the number of days in the month the
chart is prepared.  A database application loads the data into Sheet1, and
sheet two contains the graph.  The graph always shows 31 ...

Hi, I'd like to insert the Excel chart in Word doc. When I insert an Excel
chart with 4 series in the type of line-column. The second serie always to be
line, I want to the last serie to be line rather than second one. I know how
change it when it happens in Excel. But I cannot ...

How do I make a dial chart using Excel data?

How to create a scatter chart with spread sheet below. The x axis may be
location and Y axis are lot name
Lot    value    location
A    3    1

How to create a scatters chart? It is simple with 2 coluums as below.  I
tried the wizard but I don't  have the x axis with name such as ew, re
ytr....Need your help. Daniel
name    value

I can't get it to change the chart type on a single data series in the new
Excel 2007.  The "change chart type" is grayed out.  Thank you,

I know how to color excel bar with different colors using color index.  How
can
I add pattern with the same color using macro.  Do you know what index
number ?

It seems the legend is showing the the series by the order at which they
have been created.
Is there a way to change the "showing-order" of series -moving them up or
down-?

Okay, I'm sure I'm not using the correct language while asking this question,
so bare with me....
I have a bar chart plotting volume numbers for each package we sell.  
However, only ONE product sells over 1000 cases a week and the rest of the

I am wondering on how I can put the "names" on my bubbles...?
I've the following data where I would like to make a bubble chart with ...
The bubble chart in itself works fine, I just do not manage to get the
corresponding name (Product1, 2,...) on each bubble:

I am presenting rolling 13 weeks of data on various manufacturing
problemin our operations with a pivot chart. On the chart I would like
to show the subtotals for each problem as well but I cannot figure
out  a way of  doing this.

I have created a macro (with help from this forum) to automatically adjust
the Y axis based on the selected x axis data. The macro works but when the
macro runs it pages through all the excel sheets that I have the charts on.
Is there a change I can make to the macro so it will ...

I have produced a series of 100% Stacked Bar charts.  The charts show the
percentage of people giving ratings of very poor, poor, average, good and
very good.
I would like to add onto the charts a line which shows where above average

I cannot change the size of the printed chart in office 2007.
In 2003 it was done using un selecting the "fit to page" button.
In 2007 I have a "scale to 100%" but disabled...
Thanks

I would like to uniformly scale a chart and preserve its current look. When
I currently resize/scale a chart the entire formatting is altered and it no
longer looks correct (when I make it small, the only thing visible is the
chart title).