Forum Discussion

brendaivett's avatar
brendaivett
Icon for Advocate II rankAdvocate II
9 years ago

How to display a trend line with no initial value?

Hi,

 

Is there a way I can have a trend line, without having a corresponding value for the first set (first column)? If I only have the percentage related to the 2nd column, as it is to represent growth, it only draws a circle, and if I enter "0" for the first set of values, it displays the 0%. Can I either draw the line with no initial value or make the 0% invisible?

 

 

If it's not possible, is there any other way/visualization you would recommend?

 

Thanks!

 

Brenda

Need Help
Tips and Tricks

2 Replies

  • MFelix's avatar
    MFelix
    Icon for Super User rankSuper User
    9 years ago

    Hi brendaivett,

     

    don't know if this is what you are looking for but keeping the percentage only in the first column if you go to the option on the visual and select the Shapes you will have the option to change from the circle to a line then just put it to the max of the size and will give you something like this:

     

     

    Regards,

    MFelix

    • brendaivett's avatar
      brendaivett
      Icon for Advocate II rankAdvocate II
      9 years ago

      Thanks a lot MFelix...I'll show that to our user and see how they like that option.

       

      What they really wanted was to show the line going from column 1 to column 2, maybe having the percentage of column 1 as 0% but not show that initial value, as it is zero or blank.

       

      Thanks again!

       

      Brenda