Results 1 to 2 of 2
  1. #1
    New Lounger
    Join Date
    Jun 2004
    Posts
    9
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Linear Column Chart (Excel 2003)

    Hi,

    Does anyone know of a way to plot two series' on one column chart using different x axis(xlCategory) values. Typically, column charts have labels for the X axis but do not have real values. I am creating a histogram and want to plot one histogram on another. I ideally want to have the x axis store linear values not just labels for each column. I would appreciate any thoughts or suggestions.
    Thanks.

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Linear Column Chart (Excel 2003)

    For a column chart, the x axis is always categorical, so if you want to treat it as a scalar axis, you must fake it by providing the correct data.
    If you use an XY scatter chart, Excel will automatically treat the x axis as scalar, so no special tricks are needed.

    See the attached workbook. The original data series are highlighted in yellow, the combined data on which the chart is based are highlighted in pale green.
    Attached Files Attached Files

Posting Permissions

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