I have some 3 columns of data in Excel :-
1st column has category names
2nd column has figures associated with these
3rd column more figures

I have a scatter graph but would like to be able to edit the screen tip -
when I hover over a point the screen tip shows the x and y values. I have a
look up to the x value - this is not ideal as the x value may not be unique
and requires the user to input the x value to a cell ...

I have a workbook (Excel97) that has a spider chart with 14 dots. I
have code that sets the color of each dot according to the score the
dot represents. The dot values are set by a single series of cells. I
go through the legend items to change the dot color.

How do I have create a line graph with 3 lines having a common point of
reference or origin?  I see financial charts showing investments, for
example, having $10,000 as a point of origin in order to show change in
investment value over time.  I want to do something like that with ...

Excel Charts:  In the "Format Axis" window, (perhaps in the "Scale" tab)
allow users to define, select, and format single axis lines.  This will allow
the user to display charts that have goals or % complete views.
----------------

Hi people,
My problem is I have a graph with lots of data on it, so much that it
is hard to spot useful inofrmation in it. Short of simply expanding the
graph width, or making multiple graphs of different sections of data,

I would like to copy and paste an excel graph into aonther workbook
without including the underlying data series. In other words, I would
like the graph to exclude all formulas (similar to paste special>
values when dealing with formulaes).

I have a big bar chart that just barely fits on my page. Excel keeps
dropping every other data label. I have it setup so everything fits
niceley on the spreadsheet.
Sometimes the print preview shows all labels visible but every other

I have a chart which pulls data from various worksheets.  The dat
changes monthly, so each new month there are lots of blank cells whic
don't yet have values.  But the chart continues on for the blank days
giving each a value of zero (even though the cells contains spaces, no

I have created a number of charts as stand alone sheets. I now want to resize
these charts so that they are in the dimensions of the ppt or word table,
that I would like to paste them in. Forgive the lack of precise terminology,
but the sheets take up the whole screen and are not ...

When I create bar chart with relatively long lables for categories on Y
(left) axis the program by default puts the label in one line. This means
that sometimes half of my screen is occupied by labels (i.e. "exchange of
cell phone ringtones") and the other half are the actual ...

Please help!  I have a worksheet with an embedded chart in it.  The
chart background is coloured blue and the pie chart within it is multi
coloured.  When I click on print preview I can see the worksheet with a
blue box where the chart is but the multi-coloured pie chart has

How can you add a trendline to a stacked bar graph? Thanks

For instance, if I have a single series chart with Y axis from 0% to 5%, how
do I put a red color from 0 to 2%, green from 2 to 4% and blue from 4 to 5%?

in a chart in excel, is there a way to take one column and find out how many
times numbers pop up.  say numbers 1-42, I want to know how many times each
of the numbers show up.