Forum Discussion
Solved
Converting a range to a table removes chart bound options
Hi, I'm having a problem that is causing a lot of frustration, it's easiest to demonstrate how to reproduce this: For this example I have entered dummy data/headers into a fresh spreadsheet, I ha...
Drahnier When you convert a range of cells into a structured table whatever is in the header row becomes text. So, the dates are no longer numeric values that Excel can use in setting boundaries to the axis. If you want to work with dates in a structured table you must put them in a column.
Drahnier When you convert a range of cells into a structured table whatever is in the header row becomes text. So, the dates are no longer numeric values that Excel can use in setting boundaries to the axis. If you want to work with dates in a structured table you must put them in a column.
- Thank you, looks like this is the answer, though I wish it wasn't.
