How to apply conditions on charts

Hi Guys

I'm new to using Macros and vba code in Excel and am getting problems in creating dynamic charts. Although I had seen all the posts of condional charts in search forum but no use.
I have an excel sheet with Date Received Column,Volume Unprocessed and the third column is to add 5 working days in the date received.I have to ask three questions.Please find enclosed the attachment.
1)In the attachement ,the excelsheet has 4 rows and chart for these values is displayed in chart1. But when new values are added up,it doesn't show those values in the chart automatically and I think I need macro for this.
2) I want macro to automatically calculate date by adding 5 working days in the date received for the rest of the rows.
3) If the current date is equal to date in the third column then the bar should be in orange colour. If the current date is greater than the date in 3rd column then the bar should be green colour and if its less then bar should
be red.
Could anyone please help me out to solve this.

Regards
Aman

Your post does not comply with Rule 1 of our Forum RULES. Your post title should accurately and concisely describe your problem, not your anticipated solution. Use terms appropriate to a Google search. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will be addressed according to the OP's experience in the forum: If you have less than 10 posts, expect (and respond to) a request to change your thread title. If you have 10 or more posts, expect your post to be locked, so you can start a new thread with an appropriate title.
To change a Title on your post, click EDIT then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.

No need for code.

Add 3 columns to perform conditional test.
Use 3 series in your bar chart based on the 3 columns.
Format fill colour as required. Set Overlap to 100%

I have changed the Y axis to be Category rather than time series in order to remove the gaps for days you have no data for.

I turned the data table into a List object so the chart will automatically exapand to include new rows and the formula will auto populate.

Did you try the file I attached? Entering new data will automatically update chart and formula.

Please amend you question title.

Because you are not adding information to the list object.

Select a cell in the range A1:F5 you should notice the big blue border, the automatic dropdown filters and the astrisk for entering of New row.

If you enter your data there everything will be automatic.

In that case then maybe using named ranges would be the simplest approach.
There are many examples of those of the formula.

You will though need to update the formula used in the 3 columns when updating the sheet.

As I said there are plenty of examples already posted on the forum, use the search.

There are also plenty of examples here,
http://peltiertech.com/Excel/Charts/Dynamics.html