I used a bullet chart instead, & created a sheet for each quarter, then pulled the two together into a dashboard. Will this work? (see attached)
The simplest way to do bullet charts is to select 2 measures, & click the bullet graph on the showme toolbar.
MonthlyProgressChart.twb.zip 33.1 KB
Thanks for taking a look at this. I am looking for something that provides all four measures on one line by project, very much like a Gantt chart, but I have no dates. I am looking to create two points - Q1 Planned and Q2 Planned. Then a bar showing the quaterly progress, which is the delta between Q2 Actual and Q1 Actual.
Any more ideas?