• 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.

Dynamic Chart with Years in Series (Legends)

meami111

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
 

Attachments

  • Test_Book.xlsx
    12.2 KB · Views: 2
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
66532
 
Thanks a lot for the quick revert. Do you suggest any alternative way so that manual dragging can be done away with?
 
Convert your range into a table and make a chart referring to the table. Adding data to the right makes the table grow and should extend the chart too.
 

Attachments

  • Copy of Test_Book.xlsx
    14.3 KB · Views: 2
  • Like
Reactions: Hui
Back
Top