+ Reply to Thread
Results 1 to 2 of 2

A simple chart..

  1. #1
    Freddie Mac
    Guest

    A simple chart..

    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!


  2. #2
    Jon Peltier
    Guest

    Re: A simple chart..

    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
    -------
    Jon Peltier, Microsoft Excel MVP
    Tutorials and Custom Solutions
    http://PeltierTech.com
    _______


    "Freddie Mac" <FreddieMac@discussions.microsoft.com> wrote in message
    news:020AA312-90C4-45B9-A2E4-9AFEC371048C@microsoft.com...
    >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!
    >




+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1