How can a make a graphic with data from a table that have applied filters

%3CLINGO-SUB%20id%3D%22lingo-sub-2938866%22%20slang%3D%22en-US%22%3EHow%20can%20a%20make%20a%20graphic%20with%20data%20from%20a%20table%20that%20have%20applied%20filters%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2938866%22%20slang%3D%22en-US%22%3E%3CP%3EHello!%3C%2FP%3E%3CP%3EI%20want%20to%20make%20a%20line%20graphic%20with%20values%20from%20this%20table%20I%20have.%20The%20graphic%20must%20include%20on%20one%20axis%2C%20X%2C%20the%20days%20from%20a%20month%20(from%201-30%20or%201-31%20depending%20on%20the%20month)%20and%20on%20the%20other%20one%2C%20on%20Y%20axis%2C%20must%20include%20the%20hours%20in%20one%20day%20(1-24).%20On%20every%20day%20of%20the%20month%20I%20must%20have%2024%20points%20of%20value%2C%20referring%20to%20the%2024%20hours%20of%20one%20day.%20I%20have%20values%20on%20every%20hour%20of%20the%20day%2C%20for%20every%20day%20of%20the%20month.%20Every%20time%20I%20filter%20the%20table%20to%20select%20the%20values%20and%20enter%20the%20data%2C%20my%20chart%20disappears.%20In%20the%20end%2C%20I%20will%20have%20to%20have%20a%20graphic%20with%2024%20lines%20and%20for%20every%20day%20of%20the%20month%2C%2024%20values.%3C%2FP%3E%3CP%3EThank%20you%20in%20advance%20for%20all%20the%20answers.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2938866%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3ECharting%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2940328%22%20slang%3D%22en-US%22%3ERe%3A%20How%20can%20a%20make%20a%20graphic%20with%20data%20from%20a%20table%20that%20have%20applied%20filters%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2940328%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1211210%22%20target%3D%22_blank%22%3E%40LorenaM%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EExcel%20365%20Pro%20Plus%20with%20Power%20Pivot%20and%20Power%20Query.%3C%2FP%3E%3CP%3EGraph%20power%20usage%20vs%20hour%20for%205%20days.%3C%2FP%3E%3CP%3ENot%20a%20problem%20with%20this%20Excel%20version%20and%20this%20layout.%3C%2FP%3E%3CP%3EShare%20file%20and%20database.%20Include%20filter%20specs.%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fwww.mediafire.com%2Ffile%2F1cfanxag0pw1iot%2F11_08_21a.xlsx%2Ffile%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fwww.mediafire.com%2Ffile%2F1cfanxag0pw1iot%2F11_08_21a.xlsx%2Ffile%3C%2FA%3E%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fwww.mediafire.com%2Ffile%2Fyrp4xskfoa14bcm%2F11_08_21a.pdf%2Ffile%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fwww.mediafire.com%2Ffile%2Fyrp4xskfoa14bcm%2F11_08_21a.pdf%2Ffile%3C%2FA%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2958274%22%20slang%3D%22en-US%22%3ERe%3A%20How%20can%20a%20make%20a%20graphic%20with%20data%20from%20a%20table%20that%20have%20applied%20filters%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2958274%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%2F1211210%22%20target%3D%22_blank%22%3E%40LorenaM%3C%2FA%3E%26nbsp%3B%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20attached%20a%20sample%20image%20of%2024%20hours%20chart.%20Data%20refresh%20in%20chart%20automatically%20as%20you%20change%20your%20data%20selection.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EYou%20can%20check%20here%20for%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3E%3CA%20title%3D%22No%20Code%20Data%20Visualization%20Add-In%22%20href%3D%22https%3A%2F%2Fchartexpo.com%2FutmAction%2FNCtNVEMreGwrUUorTVNPRlRDTVQr%22%20target%3D%22_blank%22%20rel%3D%22noopener%20nofollow%20noreferrer%22%3EMicrosoft%20Excel%20%26amp%3B%20Office%20365%3C%2FA%3E.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAnd%20if%20you%20are%20comfortable%20with%20Google%20Sheets%2C%20you%20can%20find%3CSPAN%3E%26nbsp%3Bit%26nbsp%3B%3C%2FSPAN%3E%3CA%20title%3D%22No%20Code%20Data%20Visualization%20Add-On%22%20href%3D%22https%3A%2F%2Fchartexpo.com%2FutmAction%2FNCtNVEMrZ3MrUUorTVNPRlRDTVQr%22%20target%3D%22_blank%22%20rel%3D%22noopener%20nofollow%20noreferrer%22%3Ehere%3C%2FA%3E.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Qaiser_j_0-1636716496306.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F326586i96CC03115C7DBFCB%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22Qaiser_j_0-1636716496306.png%22%20alt%3D%22Qaiser_j_0-1636716496306.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

Hello!

I want to make a line graphic with values from this table I have. The graphic must include on one axis, X, the days from a month (from 1-30 or 1-31 depending on the month) and on the other one, on Y axis, must include the hours in one day (1-24). On every day of the month I must have 24 points of value, referring to the 24 hours of one day. I have values on every hour of the day, for every day of the month. Every time I filter the table to select the values and enter the data, my chart disappears. In the end, I will have to have a graphic with 24 lines and for every day of the month, 24 values.

Thank you in advance for all the answers.

4 Replies

@LorenaM 

Excel 365 Pro Plus with Power Pivot and Power Query.

Graph power usage vs hour for 5 days.

Not a problem with this Excel version and this layout.

Share file and database. Include filter specs.

https://www.mediafire.com/file/1cfanxag0pw1iot/11_08_21a.xlsx/file

https://www.mediafire.com/file/yrp4xskfoa14bcm/11_08_21a.pdf/file

 

Hi @LorenaM ,

 

I attached a sample image of 24 hours chart. Data refresh in chart automatically as you change your data selection.

 

You can check here for Microsoft Excel & Office 365.

 

And if you are comfortable with Google Sheets, you can find it here.

 

Thanks

 

 

 

 

Qaiser_j_0-1636716496306.png

 

Steps to use Chart Filters
  1. Select your data to chart.
  2. Click the Insert tab, and select the chart you want to use. I used a column chart (2d) in the video.
  3. After the chart is added to the worksheet, click Chart Filters.
  4. Uncheck the data you do not want to see in the chart.
  5. Click Apply.