A simple chart..

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I want to make a simple chart the displays values for several hundered
instruments. Each instrument has one value and each instrument has a unique
text in the excel-cell. The data is stored in the excel spreadsheet as
follows: In cells A1 to A300 I have the ID of the instrument e.g. FNMA 7.125
0307,
FVH4, etc. In cells B1 to B300 I have the valuse corresponding to each
instrument e.g. 5, 6, 10 etc. Now I want to make a chart that displays each
instrument as a point or a pole (I think it is this in English..) but excel
wont let me do it. It is too much to do by hand by selecting every instrument
as series and choosing the value. When I try to make it I just one
serie...Please please help me!
 
You can't have more than 255 or 256 series in a chart, so this approach is
going to lose from the start. If you plot the data as one series, you can
double click on it and on the Options tab, choose Vary Colors by Point. This
gives each its own formatting and its own legend entry. Of course, there is
not room for 300 legend entries on the chart, and most of the points look
like many of the other points, since there are only 56 colors, and if you're
using an XY or Line chart, 9 different marker shapes.

You have to think carefully about what it is you are trying to show with
your chart, and whether a chart is the correct means of communication.

- Jon
 
Back
Top