Hi everyone. I am a trader, i trade in the stockmarket as well as the FUTURES
market. Candlestick chart is a japanese chart used by many traders for them
to assess the market condition. How do we generate Candlestick chart using
Microsoft Excel ? Are there any available ...

I find the shadow that appears in my line charts distracting, confusing, and
graphically messy. It also is not welcome in publications. I have to
individually eliminate it from every line, which is annoying. Is there a way
to make a default chart option so that I will no longer ...

I have an array (about 15 x 15) with years 1990-2003 along the top that is
missing data in some years, i.e. one series begins at 1990 and goes to 2000
while other series begin in 1998 and goes to 2003. The array content is in
number format to the first decimal place, e.g. 14.1.  ...

Hello, I'm trying to create a chart that will mimic the candlestick chart but
it does not use a timeline. Instead of displaying the timeline along the
X-axis, it will show the thickness of the sheet.
Sample data available as follow :

i update weekly sales information for our retail stores in an Excel table.  I
also use this data to create a chart (presented below the table).  This
information used to fit nicely on a page, but as the weeks progress, the
table gets longer and longer and the printed page is no ...

I'm using XL2000.  I have a workbook with 11 sheets, 7 charts and 4 data.  
They are intermingled.  Whenever I try to print the entire workbook, any data
sheet after the first chart is blank.  They view fine in print preview, but
are blank when actually printed.  Has anyone heard ...

If I have a list like 1,2,1,5,3,4,3,5 can I get excel to sort it and delete
repeat values, giving 1,2,3,4,5?

I am working with data updated weekly, and making forecast by trend line of
last 12 weeks, if there is a way for dynamic trend line, so I dond have to
change the range every week.
Thank you

HELP.  I am trying to create a graph with 4 days figures in it in bar format.
I then want to add a line which would be the average figures. When I try and
do this the graph puts days 3 and 4 in line format.  I can add more serires
to it and this gets rid of it.  Must be a easier ...

I am using Microsoft Excel 2000.
I a range of data on claimant counts of males and females in May 2001.  i
need to construct a histogram.  i have searched the help and it hasn't given
me any useful info.

I have a sheet that records registration data. It is supported by different
Pivot Table reports. The data in the main sheet changes twice a year and I
need to find a way to clear the references that the reports use (as in 'show
all', 'blank', etc.). I can clear the data from the ...

This is extra information for my first original post
The layout of my data is 8 columns andd different amount of rows
The name of the columns are as follows:
Country(C), PlaceName(PN),   Male Claimant count(MCC),  Male Clamaint

I have made lots of charts for the graphic designer. Now she said to me
my charts are too big when she copies those to illustrator (she has to
resize every one). So she asked me to resize all the charts to the size
she wants in excel. Now, my problem is how I can automatically ...

I am trying to plot a scatter chart with percentage growth as the y axis.
The range of growths runs from negative to plus several thousand. I would
like to use a log scale but clearly this will not cope with negatives. Any
ideas would be gratefully received!

Have a chart made from a table that has bolood pressure readings as a
function of dates.
Some dates are skipped.
The chart generated now connects a line between all the dates points that