• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Excel VBA: Adding more legends in excel charts. Or can I replace legends with a text box or picture?

A

ABDUL SHIYAS A

New Member
I am generating barcharts using excel vba in which y axis meet x axis at 100. My data range is from 0 to 100. My chart has 3 series collection. So I gave red and its variants to values less than 100 and green and its variants to values greater than 100. The problem is with legends. I can have only 3 legends. It can be used to represent only either values greater than 100 or lesser than 100.
Here is the snapshot of my chart. It represents only left side.

1.JPG

I would like to have legends like this (I made this in paint).
2.JPG

Can we make this possible? Is it possible to add dummy legends? Or can I add a picture like above in the place of legends?
 
You must log in or register to reply here.
Back
Top