Forum Discussion
Solved
Excel Graphing - adding third year of data to charts
I maintain a spreadsheet with data entered daily, now in our third year. After entering the raw data into one long, ongoing sheet I gather the data into groups of 3 or 4 columns in pivot tables on s...
- it is really hard to diagnose just from pictures but it looks to me like it is the FIRST day of 2022 that is shown under the 2022 pivot which is also the only line that specifically shows the year 2022. I guess I would check the date column and make sure the DATEs that are supposed to be in 2022 are really in 2022 and not 2021.
it is really hard to diagnose just from pictures but it looks to me like it is the FIRST day of 2022 that is shown under the 2022 pivot which is also the only line that specifically shows the year 2022. I guess I would check the date column and make sure the DATEs that are supposed to be in 2022 are really in 2022 and not 2021.
