Results 1 to 4 of 4
  1. #1
    3 Star Lounger
    Join Date
    Jan 2001
    Location
    Las Vegas, Nevada, USA
    Posts
    334
    Thanks
    8
    Thanked 0 Times in 0 Posts

    Line Chart Blended w/ Area Chart for Highlighting

    I have data (Variance to Budget expressed as a percent) that ranges from -179% to +171% which I have displayed on a line chart from Jan '09 through Apr '11.

    Is there a way to highlight a range on the chart of say +/-10% or +/-15% from the zero axis?
    Perhaps even to highlight outside the +/- range so that the area above or below could be filled with some light shading while leaving the area within the +/- range with no color.

    I've been trying to work with the 100% Stacked Chart for upper and lower values and then add the Variance % data as a Line Chart.
    Attached Files Attached Files

  2. #2
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts
    Are you looking for something like:
    http://peltiertech.com/WordPress/hor...el-2007-chart/

    Steve

  3. #3
    3 Star Lounger
    Join Date
    Jan 2001
    Location
    Las Vegas, Nevada, USA
    Posts
    334
    Thanks
    8
    Thanked 0 Times in 0 Posts
    I think so. Only I'm looking to highlight a brief range (say +/- 10% over/below the zero axis) rather than the entire background. I'll give the tutorial a try to see if it helps.

  4. #4
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts
    You can not include the higher ranges (it is a stacked area). The lower areas can be "hidden" (they are still needed to placment) by removing the fill color and line color...

    Steve

Posting Permissions

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