charts

%3CLINGO-SUB%20id%3D%22lingo-sub-1454677%22%20slang%3D%22en-US%22%3Echarts%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1454677%22%20slang%3D%22en-US%22%3E%3CP%3Ehow%20do%20i%20increase%20the%20data%20range%20for%20a%20chart%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1454677%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3ECharting%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1454844%22%20slang%3D%22en-US%22%3ERe%3A%20charts%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1454844%22%20slang%3D%22en-US%22%3E%3CP%3EHi%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F695628%22%20target%3D%22_blank%22%3E%40salsequim%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3Ethere%20are%20several%20ways%20to%20do%20this.%3C%2FP%3E%0A%3COL%3E%0A%3CLI%3Eedit%20the%20chart%20and%20adjust%20the%20data%20source%20manually%3C%2FLI%3E%0A%3CLI%3Econvert%20your%20source%20data%20into%20an%20Excel%20table%20and%20use%20the%20table%20or%20its%20columns%20as%20the%20chart%20source%3C%2FLI%3E%0A%3CLI%3Ecreate%20a%20named%20range%20with%20a%20formula%20that%20calculates%20the%20range%20dynamically%20and%20use%20that%20name%20in%20the%20chart%20source%3C%2FLI%3E%0A%3C%2FOL%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1455366%22%20slang%3D%22en-US%22%3ERe%3A%20charts%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1455366%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F7724%22%20target%3D%22_blank%22%3E%40Ingeborg%20Hawighorst%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%3EI%20am%20using%20online%20excel%20and%20i%20can't%20do%20any%20of%20the%20things%20you%20suggested.%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1455464%22%20slang%3D%22en-US%22%3ERe%3A%20charts%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1455464%22%20slang%3D%22en-US%22%3E%3CP%3EHi%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F695628%22%20target%3D%22_blank%22%3E%40salsequim%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EYou%20can%20create%20two%20of%20the%20three%20suggestions%20in%20Excel%20online%20and%20the%20third%20suggestion%20can%20be%20set%20up%20in%20Excel%20for%20desktop%20and%20will%20work%20fine%20in%20Excel%20online.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E1.%20change%20the%20chart%20manually%3A%3C%2FP%3E%0A%3CP%3EIn%20Excel%20Online%2C%20select%20the%20chart%20and%20on%20the%20Chart%20ribbon%20select%20the%20%22Select%20Data%22%20command.%20Here%20you%20can%20change%20the%20range%20that%20the%20chart%20refers%20to.%20This%20works%20for%20data%20layouts%20in%20one%20contiguous%20range.%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%222020-06-11_15-25-01.jpg%22%20style%3D%22width%3A%20728px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F198017iC85DAB8473A3CEA9%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20title%3D%222020-06-11_15-25-01.jpg%22%20alt%3D%222020-06-11_15-25-01.jpg%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E2.%20using%20an%20Excel%20table%3C%2FP%3E%0A%3CP%3ESelect%20the%20data%20and%20use%20the%20ribbon%20command%20Insert%20%26gt%3B%20Table.%20With%20the%20table%20selected%2C%20insert%20a%20chart.%20When%20new%20data%20rows%20are%20added%20to%20the%20table%2C%20the%20chart%20automatically%20includes%20these%20data%20points.%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%222020-06-11_15-29-55.jpg%22%20style%3D%22width%3A%20734px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F198018i9EE9A32BB9F0A611%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20title%3D%222020-06-11_15-29-55.jpg%22%20alt%3D%222020-06-11_15-29-55.jpg%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E3.%20Set%20up%20dynamic%20range%20name%20formulas%20and%20connect%20them%20to%20charts%20in%20Excel%20for%20desktop.%20Then%20you%20can%20use%20Excel%20online%20to%20add%20new%20data%20and%20the%20charts%20will%20update%20automatically.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3ESome%20more%20sophisticated%20techniques%2C%20like%20dynamic%20range%20names%2C%20can%20only%20be%20configured%20in%20Excel%20for%20desktop%2C%20but%20once%20they%20have%20been%20set%20up%2C%20the%20will%20work%20in%20Excel%20online%20as%20well.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1457964%22%20slang%3D%22en-US%22%3ERe%3A%20charts%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1457964%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F7724%22%20target%3D%22_blank%22%3E%40Ingeborg%20Hawighorst%3C%2FA%3E%26nbsp%3B%26nbsp%3B%3C%2FP%3E%3CP%3Ethis%20is%20what%20i%20had%3A%3C%2FP%3E%3CTABLE%20width%3D%22140%22%3E%3CTBODY%3E%3CTR%3E%3CTD%20width%3D%2276%22%20height%3D%2220%22%3E12%2F31%2F2019%3C%2FTD%3E%3CTD%20width%3D%2264%22%3E1575758%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20height%3D%2220%22%3E1%2F31%2F2020%3C%2FTD%3E%3CTD%3E1570372%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20height%3D%2220%22%3E2%2F28%2F2020%3C%2FTD%3E%3CTD%3E1479152%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20height%3D%2220%22%3E3%2F23%2F2020%3C%2FTD%3E%3CTD%3E1254700%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20height%3D%2220%22%3E3%2F24%2F2020%3C%2FTD%3E%3CTD%3E1297200%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20height%3D%2220%22%3E3%2F26%2F2020%3C%2FTD%3E%3CTD%3E1364800%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20height%3D%2220%22%3E3%2F27%2F2020%3C%2FTD%3E%3CTD%3E1337400%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20height%3D%2220%22%3E3%2F30%2F2020%3C%2FTD%3E%3CTD%3E1356388%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20height%3D%2220%22%3E3%2F31%2F2020%3C%2FTD%3E%3CTD%3E1341995%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20height%3D%2220%22%3E4%2F1%2F2020%3C%2FTD%3E%3CTD%3E1305726%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20height%3D%2220%22%3E4%2F2%2F2020%3C%2FTD%3E%3CTD%3E1320810%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20height%3D%2220%22%3E4%2F3%2F2020%3C%2FTD%3E%3CTD%3E1308577%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20height%3D%2220%22%3E4%2F6%2F2020%3C%2FTD%3E%3CTD%3E1361615%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20height%3D%2220%22%3E4%2F9%2F2020%3C%2FTD%3E%3CTD%3E1405628%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20height%3D%2220%22%3E4%2F14%2F2020%3C%2FTD%3E%3CTD%3E1424462%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20height%3D%2220%22%3E4%2F15%2F2020%3C%2FTD%3E%3CTD%3E1404804%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20height%3D%2220%22%3E4%2F17%2F2020%3C%2FTD%3E%3CTD%3E1435320%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20height%3D%2220%22%3E4%2F22%2F2020%3C%2FTD%3E%3CTD%3E1415268%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20height%3D%2220%22%3E4%2F24%2F2020%3C%2FTD%3E%3CTD%3E1425346%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20height%3D%2220%22%3E4%2F28%2F2020%3C%2FTD%3E%3CTD%3E1437160%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20height%3D%2220%22%3E5%2F1%2F2020%3C%2FTD%3E%3CTD%3E1419274%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20height%3D%2220%22%3E5%2F8%2F2020%3C%2FTD%3E%3CTD%3E1454076%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20height%3D%2220%22%3E5%2F15%2F2020%3C%2FTD%3E%3CTD%3E1429357%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20height%3D%2220%22%3E5%2F22%2F2020%3C%2FTD%3E%3CTD%3E1461225%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20height%3D%2220%22%3E5%2F29%2F2020%3C%2FTD%3E%3CTD%3E1490420%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20height%3D%2220%22%3E6%2F5%2F2020%3C%2FTD%3E%3CTD%3E1540334%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20height%3D%2220%22%3E6%2F13%2F2020%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3C%2FTR%3E%3C%2FTBODY%3E%3C%2FTABLE%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fonedrive.live.com%2Fedit.aspx%3Fresid%3D8AA6BE56553C7AF3!19885%26amp%3Bcid%3D35d5a5e7-292b-468e-bb9a-94482bbd06b4%26amp%3Bithint%3Dfile%252cxlsx%26amp%3BwdOrigin%3DOFFICECOM-WEB.MAIN.MRU%22%20target%3D%22_self%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fonedrive.live.com%2Fedit.aspx%3Fresid%3D8AA6BE56553C7AF3!19885%26amp%3Bcid%3D35d5a5e7-292b-468e-bb9a-94482bbd06b4%26amp%3Bithint%3Dfile%252cxlsx%26amp%3BwdOrigin%3DOFFICECOM-WEB.MAIN.MRU%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1462355%22%20slang%3D%22en-US%22%3ERe%3A%20charts%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1462355%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F7724%22%20target%3D%22_blank%22%3E%40Ingeborg%20Hawighorst%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20used%20the%20table%20mode%20and%20it%20worked.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1495014%22%20slang%3D%22en-US%22%3ERe%3A%20charts%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1495014%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F7724%22%20target%3D%22_blank%22%3E%40Ingeborg%20Hawighorst%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThe%20table%20doesn't%20add%20to%20the%20chart%20without%20changing%20the%20range.%26nbsp%3B%20%26nbsp%3BThe%20x-axis%20data%20goes%20from%20months%20to%20each%20entry.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
Occasional Contributor

how do i increase the data range for a chart

6 Replies
Highlighted

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

 

Highlighted

@Ingeborg Hawighorst 

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

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.

2020-06-11_15-25-01.jpg

 

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.

2020-06-11_15-29-55.jpg

 

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.

 

Highlighted

@Ingeborg Hawighorst  

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-94482bb... 

Highlighted

@Ingeborg Hawighorst 

I used the table mode and it worked.

Highlighted

@Ingeborg Hawighorst 

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