Bullet Chart add-in

Question

I would like to use the Bullet Chart add-in to track our various campaigns we run annually. My thinking was that I would have a simple chart that has the Campaign titles and the Budgeted amount for each campaign and then I can import a report (that includes year to date and campaign names that are the same as the simple chart) weekly from our database. I would then simply drag the gift amount into the "value" field and it would show me how much of the budgeted amount (organized by campaign) has been raised. The problem is that when I drag the gift amount from my newly imported spreadsheet, it then sums all of the budget and changes the ranges in each of my campaigns &nbsp;from the amount each campaign needs to make to equal the sum of all the campaigns. I simply want to see how much each campaign needs to make, with a bar that tells me where we stand. Solutions?

anonymous · Answer

Anonymous,  Drag campaign names to “Category” field of Bullet Chart, you will get gift amount of each campaign. And you can set a target value for the gift amount and drag target to “Target” field of Bullet Chart, you will be able to check if gift amount of each campaign meets the target requirement.  If you still have issues with creating the chart, please share sample data of your table and post expected result.  Regards, Lydia

Forum Discussion

Related content

Embedding bullet chart in a table

Stacked Bullet Chart

bullet chart

Add total in line chart

Bullet chart for Power BI.