I am trying  to create a line with year on X axis, value on Y axis, but are
having trouble.
then, I am trying to follow the excel tutorial on the web  to create a
chart, but are   having a problem on step 7, I am not able to enter 1 in the

I have a need to plot two issues on an xy.
I need a plot point for maybe 2 to 6 different products.
I will plot dollars on vertical and a complexity value
(1to6) on the horizontal.

Is there any way, when using a logarithmic scale in an
Excel chart/graph, to show on the Y-axis the numbers
(Y-axis labels) other than those of 10 to successive
exponents (i.e., other than 0, 1, 10, 100, 1000, etc.)

I want to map on an x-y chart two issues about 2 to 4
products
I want to map the products by 1) there price & 2) there
complexity

My chart shows temperatures in fresh water.  The Y-axis
is turned to show the depth of the lake by double-
clicking the scale. In this dialog box I can put in the
maximum and minimum values and a value to show how the

I want to eliminate spikes from my line graph by not plotting zero
values.  I want to show a blank instead of a zero value on the
spreadsheet, and I'd like to join each of the 'peaks' together.
How do you do this??

I posted on 3 August ("Growth function falls over..") about LOGEST's
inability to handle missing data.
My data [x=120, 150, 200, 235; y=100, 75.5, 61.2, 50.1) plots on a log/lin
plot (x-y scattergraph).

Hi:  I have a series of data like this...
Account  Company A        Company B        Company C
Growth    12%                    20%                    5%
Sales        $100                    $200                   $50

I have a 2 line chart, Y scale is from 50,000 to 350,000.  One line is
entirely between 50,000 and 100,000 - the other is between 200,000 and
350,000.
I would like to get a little more resolution for the 50-100K by dropping out

I have created a spreadsheet and related charts in Excel
2002. The Charts created fine, but I can not figure out
how to sort the data columns in the chart from highest to
lowest. How can I sort the chart columns?

I have a simple need.  I have calculated cummulative % of
full year's sales for several years and want to compare
the sales patterns.  The chart would show each year's
sales from 0% up to 100% with % as Y axis and day of year

I need to take a random sample of 400 rows out of 16,000.
What would be the best function in excel to use?

I have a problem with charting a Dynamic chart.
I goes ok to set up the dynamic function as a range. It also shows the
correct series. The range is as follows:
=OFFSET(Sheet3!$A$1;1;Sheet3!$P$2-1;COUNTA(INDIRECT("C"&Sheet3!$P$2;FALSE));1)

I'm using Excel XP.  I have a graph with 7 different lines
and I would like to have one of the lines really stand
out.  To do this, it would be nice to make this line
thicker and bolder than the others.  However, the thickest

Help, I have a chart that automatically goes to another
worksheets chart in some other workbook and updates the
chart with that data and not the data I have in my work
sheet.  How do I turn off the auto update?