Bullet Chart add-in

[Anonymous]

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  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?

[v-yuezhe-msft]

@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