I don't want to display zeros in my line chart.  The cells are not empty -
they contain a formula.  I have used a simple if statement to hide a zero
value - however the chart is still showing the datapoint as zero.

In a pie chart if there are multiple slices, then the readability decreases.
Therefore I am interested in knowing if excel provides a way of restricting
the number of slices, yet accounts for the total picture.
For example if there are 25 slices created, I would like the pie chart ...

Dearest Wizards,
Col A has dates, in order but with most recent toward top.  Col D has data
to be graphed.  What I want is for the resulting graph to have the most
recent date on the RIGHT side of the graph (on the X-Axis) and the earliest

I m using Excel 2003 and charting activities relating to phases of the moon.
To make the chart more interesting, rather than having just "Full", "First
Quarter", etc. along the axis, I would like to use miniature pictures that
are saved as jpeg files.

I've recently switched to office 2007 and made a chart, but I am unable to
chabge the text direction in the chart. Can anyone assist me? I was able to
do this easily in office 2003.

I have a template file in Excel which contains some sample charts. I need to
generate some charts which has the same format as that of sample charts. I'm
using VB.NET 2005.

If I have a chart set up oin one sheet and need the same chart on a differnet
sheet, but with the data on the new shee represented...do I have to
physically change the source on every sheet I copy it to or can it be
"programmed" to do it automatically? (I have 100 sheets and 4 ...

I have a sheet with four columns of data. The first column is date/time
information for the X-Axis. Every day, two new rows are added at the bottom.
I have to manually change the source data range each time to include these
newly added rows of data. Is there a way to specify that ...

In MS Excel, I design an invoice which show total of Invoice in Value (i.e.
in number) and the same is to be write in word. For example - $150 to be
automatically write as "one hundred fifty" in MS Excel. Please which MS Excel
function to be used.

I have five columns of data on two different sheets in the same workbook. One
set of columns is sorted in ascending date order the other in descending date
order. When I enter data into the last row of Sheet 1, I need the data in
that row in columns A, B, C and D to be copied ...

How do I set up a graph that has a x and y axis like a t-chart, but show the
points and intersection, of the poins with an arrow going throw them. x
points would be (0,1,-1) and y points would be (-7,3,-2 ).

Im trying to put a scroll bar on a line chart in excel 2007 using 3 lines of
horizontal data from another worksheet, the top line is the period
labels(p1,p2,p3 etc) the other 2 lines underneath are performance figures and
the target amount, i want to display any 12 periods of 24 ...

I have a chart on the same page as the data which has worked well for 2
years, now the chart window is greyed out until I click on it.
I tried to reduce the number of data points and even created a new chart,
but it's still the same does anyone know why and how I can resolve it ?

I have several charts that are displayed as their on worksheets in excel 03
but don't show up in excel 07 how can i fix it so that these charts will
display?

How can I create a bar chart with character data in x and y axis,  not
number?
The bar chart is used for tracking production with lot name in y axis and
step name