3 Replies Latest reply on Jul 20, 2016 10:14 PM by Ashish Chaudhari

    How to create a asterisk reference

    Alice Chang

      Hi,

       

      I would like to create a graph like the following picture with reference line and reference asterisk.

      Can anyone help me to figure out how to create this?

       

      Thanks,

       

      Asterisk..png

        • 1. Re: How to create a asterisk reference
          Ashish Chaudhari

          Hi Alice,

           

          Please find the attached workbook for your reference.

           

          Steps are below

           

          1st - Create the below view

           

          2nd - Go to show me section and click on this highlighted option.

          3rd - After clicking this you will get the below output. You can go to edit axis and remove the 60%,80% reference line.

           

           

          which will result in

           

          4th - Add the profit to the column shelf and dual axis the same. you will get the below output. Change the chart type the way you need.

          For profit change the chart type to shapes and put measure names in the the Shape shelf. This will help you to assign shape to profit. Double click on the last highlighted section (at the bottom) and assign star shape.

           

          I hope this helps. You can refer sheet15 or sheet16. There is just a change of measure that I have used.

           

          Thanks and Regards,

          Ashish Chaudhari

          1 of 1 people found this helpful
          • 2. Re: How to create a asterisk reference
            Alice Chang

            Hi Ashish,

             

            Thank you for the quick answer. It is such a clear and useful instruction. I did complete the graph by your instruction.

             

            Many thanks,

            Alice

            • 3. Re: How to create a asterisk reference
              Ashish Chaudhari

              Hi Alice

               

              Glad my instructions helped you.

               

              Can you please Mark my response as correct and close the thread? Please refer to the below image where I have highlighted "Correct Answer" button.

               

              Thanks And Regards,

              Ashish Chaudhari

              1 of 1 people found this helpful