Forum Discussion

LorenaM's avatar
LorenaM
Copper Contributor
Nov 08, 2021

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

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.

Charting
excel

2 Replies

  • Qaiser_j's avatar
    Qaiser_j
    Brass Contributor
    Nov 12, 2021

    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 https://chartexpo.com/utmAction/NCtNVEMreGwrUUorTVNPRlRDTVQr.

     

    And if you are comfortable with Google Sheets, you can find it https://chartexpo.com/utmAction/NCtNVEMrZ3MrUUorTVNPRlRDTVQr.

     

    Thanks

     

     

     

     

     

Resources