Get instant live expert help on I need help with excel chart data range

“My Excelchat expert helped me in less than 20 minutes, saving me what would have been 5 hours of work!”

Post your problem and you’ll get expert help in seconds.

Our professional experts are available now. Your privacy is guaranteed.

Here are some problems that our users have asked and received explanations on

"Source range" for chart data will not dynamically adjust; all offset formulas correct. Chart data updates from another sheet with formulas, works fine; chart will not resize, it is default expanded (source range) and will not contract/shrink when corresponding data changes. Need help, frustrated!
Solved by G. J. in 22 mins
Create Dynamic range as date source in a chart (3 trend lines). USE DATA A2:D20 (Dynamic range!!) to update the chart shown (totals column is using the secondary axis on the right hand side of the chart).
Solved by T. S. in 27 mins
The "source range" of my chart data does not dynamically change when I select an different chart. my data is fed into the "chart data range" via a drop down menu and info comes from another sheet. I am using offset formulas. The source range does adjust size based on data in the table and is stuck fully expanded, making the charts look like they are missing data
Solved by O. U. in 13 mins
I used to copy rows of data from one Excel 2013 workbook and then insert the copied data rows into another and all my chart ranges expanded as long as i inserted the rows within the rows already in the chart range but since Excel 365 the chart ranges no longer expand to accommodate the new rows of data....????
Solved by Z. S. in 27 mins
The "Source Range" of my data located in a chart does not dynamically adjust when the data is changed
Solved by S. A. in 12 mins