Results 1 to 5 of 5
  1. #1
    Star Lounger
    Join Date
    Jun 2010
    Location
    Quincy, MA
    Posts
    62
    Thanks
    2
    Thanked 0 Times in 0 Posts
    Hi, I'm trying to use a Line Chart with a Data Table that carries 3 things: Incidents, Incidents To Review, and the their Sensitivity (High, Med, Low). I realize that the first two are numeric while the third is text. Is there a way to either hide the numeric "Sensitivity" values in the Chart's Data Table, OR, is there a way to translate the numbers in the Data Series and the Data Table to show High, Med, Low? Please see the attached file for a better understanding. If choosing another graph type allows for this, that's great but can you tell me what type you used and how you laid out the data series please? Thanks, Pete
    Attached Files Attached Files

  2. #2
    5 Star Lounger
    Join Date
    Dec 2009
    Location
    East Coast, USA
    Posts
    993
    Thanks
    8
    Thanked 43 Times in 43 Posts
    Quote Originally Posted by Pete Sweeney View Post
    Is there a way to either hide the numeric "Sensitivity" values in the Chart's Data Table,
    Hello Pete- Can hide "Sensitivity" in a couple of ways...
    1) To hide Sensitivity from the "data" and "chart" , Right click on the top of Column D and choose Hide.
    or
    2) To see the Sensitivity data in the table, but not in the chart, change Source Data from A113 to A1:C13.

    Next question....
    OR, is there a way to translate the numbers in the Data Series and the Data Table to show High, Med, Low?

    What are the values that determine High, Med, Low?

    Tim

  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 all it is formatting the numbers to display something else and there is only 3, you could custom format the data cells to:

    [=12]"Low";[=25]"Med";"High"

    And they will display Low, Med, High in the range and in the datatable, but plot as 12, 25, 49...

    Steve

  4. #4
    Star Lounger
    Join Date
    Jun 2010
    Location
    Quincy, MA
    Posts
    62
    Thanks
    2
    Thanked 0 Times in 0 Posts
    Quote Originally Posted by Tim Sullivan View Post
    Hello Pete- Can hide "Sensitivity" in a couple of ways...
    1) To hide Sensitivity from the "data" and "chart" , Right click on the top of Column D and choose Hide.
    or
    2) To see the Sensitivity data in the table, but not in the chart, change Source Data from A113 to A1:C13. Need to show in graph, but want to show text not numbers.

    Next question....
    OR, is there a way to translate the numbers in the Data Series and the Data Table to show High, Med, Low?

    What are the values that determine High, Med, Low? 49, 25, 12

    Tim

  5. #5
    Star Lounger
    Join Date
    Jun 2010
    Location
    Quincy, MA
    Posts
    62
    Thanks
    2
    Thanked 0 Times in 0 Posts
    Quote Originally Posted by sdckapr View Post
    If all it is formatting the numbers to display something else and there is only 3, you could custom format the data cells to:

    [=12]"Low";[=25]"Med";"High"

    And they will display Low, Med, High in the range and in the datatable, but plot as 12, 25, 49...

    Steve
    This is brilliant! Thank you 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
  •