Results 1 to 6 of 6
  1. #1
    JoeBob
    Guest

    Graphics (Excel 2000)

    A series of inputs of type x, y.
    The differences between the x values are not constant (some are 1, others 10, others 9, others 20, etc ...).
    The graphical display of these values has a uniform scale (width) of the x values. A 10 or a 30 or a 17 has the same width as a 1. Consequently the produced graphic is not mathematically correct.
    Is there a way to display cell width in relation to cell value ?

  2. #2
    Uranium Lounger
    Join Date
    Jan 2001
    Location
    South Carolina, USA
    Posts
    7,295
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Graphics (Excel 2000)

    I'm not completely clear on exactly what you are trying to do. Are you trying to do graphicsin the spreadsheet rather than using the graph capabilities?

    If so, you are going to need to use VBA code to set the cell widths. However, you are still going to have some problems since all of the cells in a column must be the same width. To do what I think you are trying to do, you would have to use cells in multiple columns to depict different magnitudes. One column for one, two columns for 2, 30 columns for 30, etc. The VBA code could color the cells to show magnitude.
    Legare Coleman

  3. #3
    JoeBob
    Guest

    Re: Graphics (Excel 2000)

    Sorry for the confusion.
    Yes, trying to do this in graphical mode.

  4. #4
    Uranium Lounger
    Join Date
    Jan 2001
    Location
    South Carolina, USA
    Posts
    7,295
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Graphics (Excel 2000)

    Sorry for being so dense, but what do you mean by "graphical mode." Could you attach a workbook that shows what you are trying to do?
    Legare Coleman

  5. #5
    2 Star Lounger
    Join Date
    Jan 2001
    Location
    Chicago, Illinois, USA
    Posts
    187
    Thanks
    6
    Thanked 0 Times in 0 Posts

    Re: Graphics (Excel 2000)

    graf it using a scatter plot

  6. #6
    3 Star Lounger
    Join Date
    Mar 2001
    Location
    Silicon Valley, California, USA
    Posts
    273
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Graphics (Excel 2000)

    Generally, if a graph shows uniform spacing with respect to the X axis, despite the values not being uniformly spaced numerically, it means you are trying to use a "line" chart and expecting it to behave like a "scatter" chart.

    The comment about cell width is confusing. Do you mean, distance in X between points, or do you means cell width on a worksheet? If you really mean cell width, are you really talking about a chart, or some visual cue through formatting?

Posting Permissions

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