How to set table columns values in y axis and dates in x axis in bar chart in C# windows form

See more:

C#

SQL

i have tried to display table column values as bar chart representation.

i have to set the x axis value as last seven days from current day
(ie) if current day is 21-05-2022, i have to set upto 15-05-2022.


my code shows the table values in bar chart.
but how can i set dates in x axis.?
please help!

What I have tried:

SQLQuery = "SELECT CONVERT(DATE,TransDate) AS Dates,SUM(CASE WHEN TStatus = 'IW' THEN 1 ELSE 0 END) AS Check_In,SUM(CASE WHEN TStatus = 'OW' THEN 1 ELSE 0 END) AS Check_Out FROM Transactions WHERE CONVERT(DATE, TransDate) >= DATEADD(day, -7, GETDATE()) GROUP BY CONVERT(DATE, TransDate) ORDER BY CONVERT(DATE, TransDate)";


            DataSet ds = new DataSet();
            objBO.QueryType = SQLQuery.ToString();
            ds = objBAL.GetSearch(objBO);

            if (ds.Tables[0].Rows.Count != 0)
            {

                for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
                {
                    
                    gvProduct.AutoGenerateColumns = true;
                    gvProduct.DataSource = ds.Tables[0];

                    gvProduct.DataBindings.ToString();
                }

            }
            else
            {
                MessageBox.Show("error");
            }
            chartefficiency.Series[0].XValueMember = "Check_In";
            chartefficiency.Series[0].YValueMembers = "Check_In";

            chartefficiency.Series[1].XValueMember = "Check_Out";
            chartefficiency.Series[1].YValueMembers = "Check_Out";