Feedback by UserVoice

How can we improve Excel for Windows (Desktop Application)?

Create short cut for creating dynamic Charts in excel 2016

Create short cut for creating dynamic Charts in excel 2016.
The current process is long and not comfortable. in my opinion an easy way will make it a must.

This is how you do it in the old way http://www.criticaltosuccess.com/dynamic-charts-in-excel-resize-with-offset-function-named-ranges/

1 vote
Sign in
(thinking…)
Sign in with: facebook google
Signed in as (Sign out)

We’ll send you updates on this idea

Eitan shared this idea  ·   ·  Flag idea as inappropriate…  ·  Admin →
already supported  ·  Scott Ruble (PM MSFT) responded  · 

This has been supported for the last several versions of Excel if you use a Table as your data source for the chart.

Thanks,
Scott [MSFT]

1 comment

Sign in
(thinking…)
Sign in with: facebook google
Signed in as (Sign out)
Submitting...
  • Eitan commented  ·   ·  Flag as inappropriate

    Thanks
    as far as i can see it has only implemented if you choose a full table and not a specific line.
    [For Example i have created a table with 10 column and 5 lines and made a chart of the table. once i add a column or row the chart was updated, but when i changed my selection to one Row(drag the marked area accordingly) , adding a column did not update the chart.
    is there a place where i can find the rules for this activity?

Feedback and Knowledge Base