I have a dynamic line chart with 12 data series that each contains weekly
data for 52 weeks, and set up as a combo box chart. Currently I have data for
only 16 weeks, while the rest of the year is howing zero values. I changed
the zero to #N/A to avoid plotting that on the graph, ...

I want to sort the charts in a spreadsheet on its name and i have the
code to do this. but my code sorts the charts based on the index
value.
Is there any way to sort charts by there name.

I want to work a scatter plot chart in reverse, whereby click on the chart to
select a point and then have the chart record the x,y coordinates?  Is this
possible in Excel?  I want to create a shot chart for soccer/basketball and
want to be able to record shots by player and then ...

Am following Jon Peltier's tutorial for horizontal colour banding. However
when i convert the line graphs to stacked area type the colouring is not
appearing per the bands its suppossed to reflect.
eg.

Is there a way to have an OFFSET range of two columns? I have been using
multiple columns for my X axis values with non-dynamic charts. Now i'm
designing a dynamic chart, but Excel will not let me select two columns
(month/wk) for my X axis.

I would appreciate your help in the following issue:
We like to know what function the Excel developpers have used in Excel for
Charts/XY(scatter)/smooth lines. It iseems to us that it is a B-spline but
there are many of those around. Could you please provide us with the exact

I have an excel chart that summarizes the days I spend in the year in any of
28 different markets, although each year I probably only work 6 to 10 of
those markets.  Then I have a pie chart that puts it in perspective.  I want
the pie chart to show only the markets with values ...

I have a column with 55 rows.  If there is a value in any cell I want to
take those values (never more than 10) and create a pie chart.  The
description for each piece of the pie would come from a cell three columns
to the left in the row that has a value.

I do a weekly quality chart at work for worker performance. This is a
horizontal chart with a bar for each employee with %age on the X scale
& the Operator name on the Y. I want to include two target lines
vertically on the chart for 1 & 1.75%. So far I cannot do this anfd

Background: I am making a chart where monthly expenses are represented by
vertical bars and the monthly budget is a constant, for the entire year,
which is represented by a horizontal line. If a vertical bar for a particular
month rises above the horizontal budget line then I ...

Is it possible to create a bubble chart with two series that share the same
X and Y values.  For example:
X    Y    values1   values2
10   11    300        0

I have a chart which shows logarithmic values. The chart data is supplied
from a table that increases in size for every entry. Problem is that when
the table is in its infancy a message pops up to say "Negative or Zero
values on log charts etc etc". Is there any way to prevent ...

I have created a line chart with the x and y axes.
The x axis ranges from -10 to +10.
This is exactly a graphing problem in math!
How can I make a vertical line appear, such as x=1???

I have a modified line chart showing cumulative product cost over a twelve
month period.  The x-axis shows each month, and the data line moves right and
up increasing with the cumulative total for the months.  Right now, the first
six months are actual and second six months are ...

Hi
i need a sample template for the following requirement . please help
wanted one report to show rag status , that needs to cover the following
how to capture information to start a project