Can I use dynamic values as column headers?

jharrison225

I've created a dashboard utilizing data from one of my sheets. I'd like to show eight weeks of historical data to establish a trend, which I have sorted out, but I'd like the values in the chart to show dynamic dates instead of static week numbers. Can this be done and what would be the technique I can use? Thanks in advance for any help!

Purnima Gore_PGPS

Hi @jharrison225

Using a checkbox to include information is the report is the approach I use.

I uncheck those I don't want in the report and so those date should pull though?

thanks

Purnima

Genevieve P.

Hi @jharrison225

Column names are static, so if your sheet is set up with the column titles being the week numbers then there currently isn't a way to adjust what is shown in your report or chart. The week numbers or dates would need to be down a row instead of in a column.

If you'd like some help with this, it would be useful to see screen captures of your set up, but please either use test/example data or block out anything sensitive.

Cheers,

Genevieve