Forum Discussion

salsequim's avatar
salsequim
Copper Contributor
Jun 10, 2020

charts

how do i increase the data range for a chart
Charting
IngeborgHawighorst's avatar
IngeborgHawighorst
MVP
Jun 10, 2020

Hi salsequim 

 

there are several ways to do this.

  1. edit the chart and adjust the data source manually
  2. convert your source data into an Excel table and use the table or its columns as the chart source
  3. create a named range with a formula that calculates the range dynamically and use that name in the chart source

 

salsequim's avatar
salsequim
Copper Contributor
Jun 11, 2020

IngeborgHawighorst 

I am using online excel and i can't do any of the things you suggested.

  • IngeborgHawighorst's avatar
    IngeborgHawighorst
    MVP
    Jun 11, 2020

    Hi salsequim 

     

    You can create two of the three suggestions in Excel online and the third suggestion can be set up in Excel for desktop and will work fine in Excel online.

     

    1. change the chart manually:

    In Excel Online, select the chart and on the Chart ribbon select the "Select Data" command. Here you can change the range that the chart refers to. This works for data layouts in one contiguous range.

     

    2. using an Excel table

    Select the data and use the ribbon command Insert > Table. With the table selected, insert a chart. When new data rows are added to the table, the chart automatically includes these data points.

     

    3. Set up dynamic range name formulas and connect them to charts in Excel for desktop. Then you can use Excel online to add new data and the charts will update automatically.

     

    Some more sophisticated techniques, like dynamic range names, can only be configured in Excel for desktop, but once they have been set up, the will work in Excel online as well.

     

    • salsequim's avatar
      salsequim
      Copper Contributor
      Jun 29, 2020

      IngeborgHawighorst 

      The table doesn't add to the chart without changing the range.   The x-axis data goes from months to each entry.

    • salsequim's avatar
      salsequim
      Copper Contributor
      Jun 12, 2020

      IngeborgHawighorst  

      this is what i had:

      12/31/20191575758
      1/31/20201570372
      2/28/20201479152
      3/23/20201254700
      3/24/20201297200
      3/26/20201364800
      3/27/20201337400
      3/30/20201356388
      3/31/20201341995
      4/1/20201305726
      4/2/20201320810
      4/3/20201308577
      4/6/20201361615
      4/9/20201405628
      4/14/20201424462
      4/15/20201404804
      4/17/20201435320
      4/22/20201415268
      4/24/20201425346
      4/28/20201437160
      5/1/20201419274
      5/8/20201454076
      5/15/20201429357
      5/22/20201461225
      5/29/20201490420
      6/5/20201540334
      6/13/2020 

      https://onedrive.live.com/edit.aspx?resid=8AA6BE56553C7AF3!19885&cid=35d5a5e7-292b-468e-bb9a-94482bbd06b4&ithint=file%2cxlsx&wdOrigin=OFFICECOM-WEB.MAIN.MRU 

Resources