Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Creating an actuals vs target bar chart

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.

  • Anonymous 

    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

2 Replies

  • VijayP's avatar
    VijayP
    Icon for Community Champion rankCommunity Champion

    Anonymous 

    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

  • KerKol's avatar
    KerKol
    Icon for Power Participant rankPower Participant

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