Does anyone know how I can create a step line chart without having to have 2 data points per x-axis point.  What I want is a horizontal line until the next data point and then I want the line to go vertical.

I have stock data in excel which I'd like to chart using
the high low close option. Problem is that the data
contains zeros on some days. Can I get excel to ignore
the zeros instead of plotting them. If not what's the

I was wondering how to lookup values to the right ,
instead of left of the column with the known variable in
it. This has me stumped!
Also I was wondering if anybody knows how to use a vlookup

How do I choose every ninth row to be my Y data on a
chart?  I have 15,000 rows so picking one individually
will be time consuming.
Thank you.

Does anyone know if there is a way to stat test an Excel Bar Chart and
have it put the letter markers on the graph next to the bar chart
value?
My friend and I are trying to do this, but the only way we can come up

I have an Excel Workbook with 6 worksheet containing a
variety of charts linked to data sources in different
workbooks.  I receive the error message "No more new
fonts may be applied to this workbook" when any font

I made a bar chart everything is fine but my lables are
not under the bars they represent?? Can anyone tell me
how to fix this?

Col A has years, such as 1990 thru 2003.
Col B has numbers relevant to each year.  Sales, taxes, inventory, whatever.
I want a simple bar chart where the numbers are represented by the bars left to right.  Easy.
I want the categoty (X) axis label values to be 1990, 1001, etc instead ...

I have a number of columns of data.
All cells in a column are filled intermittently.
How do you fill cells with the last value shown.

I trying to automate the label attachments on a stacked bar chart. I
want to have the system apply them automatically. This I can do. But I
am trying to keep them from showing straight up the middle, as then
they are all bunched up togehter and un-readable. I am trying to use

I trying to automate the label attachments on a stacked bar chart. I
want to have the system apply them automatically. This I can do. But I
am trying to keep them from showing straight up the middle, as then
they are all bunched up togehter and un-readable. I am trying to use

In an area chart I want five color bands across the chart,
over which a single line series is plotted.  The Y axis is
set Minimum 70%, Maximum 115%. The area series are:
Plot area - Red (Y axis set at 115% maximum)

as in the title, I have a chart which has values less than
zero.  Positives are coloured green, but negatives are
white and i want to make them red.
all help greatly received - thanks.

how do you create a standard normal distribution chart?

Does anyone know where I can find a good on-line tutorial
or any kind of step-by-step for using pivot tables and
charts?  I'm a good Excel user, but I've never used
pivots...I prefer data sort...but now I've got to start