Results 1 to 5 of 5
  1. #1
    Lounger
    Join Date
    Nov 2012
    Posts
    49
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Talking ~ how do you add the horizontal axis labels to a scatterplot when the 'edit' button is blanked out?

    how do you add the horizontal axis labels to a scatterplot when the 'edit' button is blanked out?

  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
    Could you send an example file? Why is the edit button blanked out? Is the workbook or worksheet protected?

    Steve

  3. #3
    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
    If your question relates to adding data to a blank chart like you posted earlier [http://windowssecrets.com/forums/sho...ine-Graph-***], you need to first ADD the series (Y-values) to the chart. Then you can add/edit the categories.

    Steve

  4. #4
    Lounger
    Join Date
    Nov 2012
    Posts
    49
    Thanks
    1
    Thanked 0 Times in 0 Posts
    i did... i right click on the scatterplot with straight line and click 'select data' and the 'edit' button is still blanked out.....

    excel 2013

  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
    Have you added anything to it? You must have something created before you can edit it. If nothing else could you attach a file, demonstrating the problem and walk us through the steps you do?

    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
  •