Creating an actuals vs target bar chart

[rchi23]

Hi,

Currently I have data the shows the date when a document was done and I have target dates of when we would want them complete. I want to know if it is possible to have a bar chart the has the date that is was done as an actual bar and the target as a hollow bar.

Currently I am using the stacked bar chart, where the y axis shows the status of the document, the legend shows the type of document, and the x axis shows the week number. (the week number column was determined by using the WEEKNUM function using the dates is was completed from another column.

Is this possible or something similar to do.

Many thanks in advance.

[KerKol]

Have you thought about using a Gantt Chart or a matrix visual made like a Gantt Chart?

[VijayP · Accepted solution]

@rchi23 

as of now clustured bar chart / stacked bar chart donot support conditional formatting with multiple series.

so above option is not available on default charts. you MAY find this in custom visuals