How to include only specific columns as axis categories from an Excel Table

If you don't want to use a pivot, change the order of your columns so you can select just the columns you want. Cut the third column and insert it next to the first column. Then create the chart by just selecting the first, second and third columns.

Unfortunately with multi-level axis categories like this, I believe you can only control the vertical alignment of the inner-most axis. So, you can rotate the D1 column but not the Date, unless you put D1 to the left of Date in your data table.

PivotChart will give you more control over the formatting for nested categories.

EDIT:

It occurred to me that you could concatenate (join) the columns you want to use into a single column for the category. Then you would be able to rotate the whole thing:

=TEXT([@DATE],"dd/mm/yy")&" "&[@D1]