how to make chart taking different columns and rows

Dear all,
in the attachment i need a graph of those rows and columns having color

Do you mean that you want to plot the totals in row 14 against the dates in row 1 ?

Pete

Do you want a separate chart for every month with each category in col A and total of the month as a separate bar?

No, not at all

so you want all the months with each category in col A on one single chart. but you want your chart to only pick the total of the month from the bottom anf not individual values of each category?

you got the point

Attachment 665590
Check this image

when i click on ATTACHMENT 665590 i got this message
"Invalid Attachment specified. If you followed a valid link, please notify the administrator"

how do i attach an image over here?.... i followed the insert image button

There is a link i.e. "Manage Attachments", click on it and attach OR you may also find this link "GO ADVANCED"

check this attachment. i hope it works this time.

Look at the sheet3 i want to add PARTICULARS below the amount in the chart how do i do this, i am using office 2016

you mean you want all the 11 particulars below the amount of each bar?

or you want to display month names below the amount?

yes 11 particulars below the amount of each bar

not possible. if you want all the 11 particulars and months and total to be under the bars then it will fetch the amount of each particular for every month as well not just the total.

if you see i have already put two things i.e. PERIOD AND AMOUNT and only PARTICULARS left so I think there may be a master person at this forum who can do this. although I am not so expert in chart but at least i did a little a bit.