I am using Epplus to export some data into an Excel spreadsheet. For one sheet, I made a chart using that data and it works just fine. For another sheet of data I also need to make a chart, but in order to do this, I needed to pivot the table, which is fine. That pivot code is below: