Consulting

Results 1 to 4 of 4

Thread: Drawing two para

  1. #1

    Drawing two para

    Dear All,

    I want a parallel to x-axis a bold line (automatic) in my bar attached chart at 10% (Target) and at 20%(Threshold).

    Any Assistance.

    Rgds,

    Ahk
    Attached Files Attached Files

  2. #2
    VBAX Expert
    Joined
    May 2016
    Posts
    604
    Location
    Have you tried just drawing the line on the chart by selecting INSERT/SHAPE/LINE and then formatting the line to whatever thickness and colour you want?

  3. #3
    I can do from the line.But i want automatic in chart.

    Quote Originally Posted by offthelip View Post
    Have you tried just drawing the line on the chart by selecting INSERT/SHAPE/LINE and then formatting the line to whatever thickness and colour you want?

  4. #4
    Moderator VBAX Guru Aussiebear's Avatar
    Joined
    Dec 2005
    Location
    Queensland
    Posts
    4,997
    Location
    Quote Originally Posted by aligahk06 View Post
    I can do from the line.But i want automatic in chart.
    Then try the macro recorder to write an initial set of code, using INSERT/SHAPE/LINE with the required formatting and then post back with a sample workbook.
    Remember To Do the Following....
    Use [Code].... [/Code] tags when posting code to the thread.
    Mark your thread as Solved if satisfied by using the Thread Tools options.
    If posting the same issue to another forum please show the link

Posting Permissions

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