create pivot chart using vba

[TimTDP]

I am new to charts!
I am looking for a sample database which includes the vba code to create pivot charts
Can anyone assist?
I am using Office 2010

 

[SpentGeezer]

I can assist. What is your scenario?

 

[TimTDP]

I want to report data in a pivot graph

Typically the data is the following format:
DateTime (x-axis)
LoggerSerialNumber (can by multiple - multiple lines)
TemeratureReading (data)

I also want to be able to:
Change title
Change X Axis label
I thought of having fields a form for the above)

I would also like to be able to:
Select colours for each line
Set line thickness of each line

I understand that a pivot graph might be an overkill, but I have decided to user this project to learn pivot coding!