VBA: Modify chart data range

by

Offset function dynamic range makes it possible.

Sample data

enter image description here

Steps

  • Define a dynamic named range
    =OFFSET(Sheet1!$A$2,,,1,COUNTA(Sheet1!$A$2:$Z$2)) and give it a
    name mobileRange
  • Right Click on Chart
  • Click on Select Data

This screen will come

enter image description here

Click on Edit under Legend Entries.(mobiles is selected)

enter image description here

  • change the Series value to point to mobileRange named range.
  • Now if data for future months are added to mobile sales it will automatically reflect in chart.

More Related Contents:

  1. Is the . in .Range necessary when defined by .Cells?
  2. Convert an entire range to uppercase without looping through all the cells
  3. Detect if range is empty
  4. How to copy only values in excel vba from a range?
  5. Copy a selected range to another worksheet
  6. VBA Dialog box to select range in different workbook
  7. Create Chart from Array data and not range
  8. Change the Point Color in chart excel VBA
  9. How to color all the rows based on the cell values
  10. Save excel file multiple times with file names in another workbook.
  11. Read/Parse text file line by line in VBA
  12. How do I find the last column with data?
  13. Excel VBA: Answer gets “stuck”
  14. How to insert a picture into Excel at a specified cell position with VBA
  15. Save multiple sheets to .pdf
  16. Having multiple Excel instances launched, how can I get the Application Object for all of them?
  17. filter out multiple criteria using excel vba
  18. Excel VBA autofilter all but three
  19. Cells.Find() Raises “Runtime Error 91: Object Variable or With Block Not Set”
  20. Loading addins when Excel is instantiated programmatically
  21. Excel’s fullname property with OneDrive
  22. Excel VBA code to copy a specific string to clipboard
  23. How to insert an embedded picture?
  24. Merge values of column B based on common values on column A
  25. How to import a table from web page (with “div class”) to excel?
  26. Copy Excel range as Picture to Outlook
  27. Excel VBA – Range.Copy transpose paste
  28. Obtain attribute names from XML using VBA
  29. Return RGB values from Range.Interior.Color (or any other Color Property)
  30. Translate text using vba

Leave a Comment