• 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


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

Dynamic Chart with Years in Series (Legends)


New Member
Hello I want to create a Dynamic Chart which is having Years as Series (Legends) and Functions as Horizontal Axis Labels (Categories). I am unable to include one named range in the series part. Please help



Excel Ninja
Staff member
It can't be done for what you want
The easiest way to manually do it is top select the chart
Click on the plot area until the Chart data is shown
Then drag the small Lower Right square across one cell


New Member
Thanks a lot for the quick revert. Do you suggest any alternative way so that manual dragging can be done away with?