Page 1 of 2 12 LastLast
Results 1 to 15 of 16
  1. #1
    Gold Lounger
    Join Date
    Feb 2004
    Location
    Cape Town, RSA
    Posts
    3,444
    Thanks
    0
    Thanked 1 Time in 1 Post

    2 Q's on a chart (Excel 2002)

    In the attached WB you will discover a chart. The target range is plotted as a line chart to indicate a target sale requirement.
    My 2 Q's are:
    1. If I use the Vary color by point option on the line, it seems like I cannot format the weight thicker. I would like to keep the varying colour, but I do want the target line to be thicker. Is there a way to have both slices of the cake?
    2. Is there any way to extend the line to the edges of the chart plot area. It does awkward if it just stops in the middle of the two columns.

    TX
    Regards,
    Rudi

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

    Re: 2 Q's on a chart (Excel 2002)

    1) Not as far as I know (I can't think of a good reason for wanting it- it's a horizontal line representing a single number)
    2) No.

  3. #3
    2 Star Lounger
    Join Date
    Jan 2002
    Location
    Missouri, USA
    Posts
    103
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: 2 Q's on a chart (Excel 2002)

    In regard to the second, you can use a work around.

    Add a row above the data, below the headings. Then put 5 in cell D2. Also, put 5 in cell D7. Then extend the data source from row 2 to row 7.

    Select your target line, change it to secondary axis, and change the scale to match the same scale as primary axis.

    Then select the X-axis, choose "Format axis", and in the scale tab, uncheck the box "Value (Y) axis crosses between categories".

    See Sheet2 for the final look.

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

    Re: 2 Q's on a chart (Excel 2002)

    Thanks. I knew about this one, but I was afraid that Rudi, finicky as he is, would be dissatisfied with the extra space to the left and right of the columns...

  5. #5
    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

    Re: 2 Q's on a chart (Excel 2002)

    How about this? I made 4 lines so each can be formatted differently (no vary by point) and used a sec X-axis to extend it

    Steve

  6. #6
    Gold Lounger
    Join Date
    Feb 2004
    Location
    Cape Town, RSA
    Posts
    3,444
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: 2 Q's on a chart (Excel 2002)

    Thanks Shades. Your suggestion is really appreciated and always welcome. I however did think of this too, but shows how well Hans has come to know me, I wanted to know if there was a way to extend the line without customising the worksheet. Sorry that I did not make myself entirely clear in the first place.

    PS: That work around will be handy for many people to come, so always suggest something if you have!

    PPS: Finicky....me?? I would say precise, accurate and perfectionist.....(sounds better.....shhhh!!)
    Regards,
    Rudi

  7. #7
    Gold Lounger
    Join Date
    Feb 2004
    Location
    Cape Town, RSA
    Posts
    3,444
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: 2 Q's on a chart (Excel 2002)

    Steve....wow!

    I studied up that chart, and I notice you used a custom series of source data. I was trying to see what you did, so I deleted one of the lines, and when I clicked ADD, it adds a series, but it does not give me a X and Y values text box. All I get is a Name and Values text box??? How did you construct each induvidual series??

    I dunno how you do it!!
    Regards,
    Rudi

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

    Re: 2 Q's on a chart (Excel 2002)

    Select one of the other segment series to see how it is defined.

  9. #9
    Gold Lounger
    Join Date
    Feb 2004
    Location
    Cape Town, RSA
    Posts
    3,444
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: 2 Q's on a chart (Excel 2002)

    I did.

    When I select one of the segments, the options for an X and Y values textbox comes up where the details can be specified. So when I want to create a new segment, I choose ADD, which creates a new series, but it only provides the Name and one values textbox in the dialog. Unless I am missing a simple setting or step, I cannot seem to get the X/Y values text boxes to define the segment!
    Regards,
    Rudi

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

    Re: 2 Q's on a chart (Excel 2002)

    The easiest way to add the series again is:
    - Select E3:F4.
    - Drag this range by its edge and drop it onto the chart.
    - Tick the check box 'Categories (X Labels) in First Column'.
    - Click OK.

  11. #11
    Gold Lounger
    Join Date
    Feb 2004
    Location
    Cape Town, RSA
    Posts
    3,444
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: 2 Q's on a chart (Excel 2002)

    I guess I can get that right ... <img src=/S/yep.gif border=0 alt=yep width=15 height=15>

    Tx a mil
    Regards,
    Rudi

  12. #12
    Gold Lounger
    Join Date
    Feb 2004
    Location
    Cape Town, RSA
    Posts
    3,444
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: 2 Q's on a chart (Excel 2002)

    How is this for an answer to 2 Q's on a chart! <img src=/S/grin.gif border=0 alt=grin width=15 height=15>

    TX again to Steve and Hans for their professional insight!
    <img src=/S/cheers.gif border=0 alt=cheers width=30 height=16>
    Regards,
    Rudi

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

    Re: 2 Q's on a chart (Excel 2002)

    With you it's more like

  14. #14
    Gold Lounger
    Join Date
    Feb 2004
    Location
    Cape Town, RSA
    Posts
    3,444
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: 2 Q's on a chart (Excel 2002)

    <img src=/S/laugh.gif border=0 alt=laugh width=15 height=15>

    Are you regretting the fact that you told me about two years back that I can ask as many Q's as I want! <img src=/S/yep.gif border=0 alt=yep width=15 height=15> Straight from the horses mouth...honest truth. I now am living up to this and I ask Q's not just for me...but for ALLLLLLL other loungers on the site! <img src=/S/grin.gif border=0 alt=grin width=15 height=15>

    I just love your humour....if that is humour.... <img src=/S/shy.gif border=0 alt=shy width=15 height=15>
    Regards,
    Rudi

  15. #15
    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

    Re: 2 Q's on a chart (Excel 2002)

    Another option would be to make the range all the points for the target, make it a wide line, just and manually change the color of each segment.

    Steve

Page 1 of 2 12 LastLast

Posting Permissions

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