Data Studio
4K members online now
4K members online now
Ask questions about Data Studio
Guide Me
star_border
Reply

bullet chart - goal and ranges from data

Follower ✭ ☆ ☆
# 1
Follower ✭ ☆ ☆

Hi,

 

Is it possible to connect data from Google Sheet to the "Bullet chart's" goal and ranges so that it automatically updates for the latests numbers? (I don't have the possibility to update the graph manually each day).

 

Best regards,

Per-Erik

1 ACCEPTED SOLUTION

Accepted Solutions
Marked as Best Answer.
Solution
Accepted by topic author Per-Erik
December 2016

bullet chart - goal and ranges from data

Explorer ✭ ✭ ✭
# 2
Explorer ✭ ✭ ✭

Hi @Per-Erik,

 

You can't make the goal dynamic at this time. One solution, which I have used, is to have 2 bar charts on top of one other, the one below linked to your 'goal' number (which in my case was linked to a Google Sheets file with 'Date' and 'Goal' in 2 columns) and the one on top linked to your actual number - this will then give the appearance of a goal chart, and will update dynamically.

 

Hope that helps,

Ben

View solution in original post

Marked as Best Answer.
Solution
Accepted by topic author Per-Erik
December 2016

bullet chart - goal and ranges from data

Explorer ✭ ✭ ✭
# 2
Explorer ✭ ✭ ✭

Hi @Per-Erik,

 

You can't make the goal dynamic at this time. One solution, which I have used, is to have 2 bar charts on top of one other, the one below linked to your 'goal' number (which in my case was linked to a Google Sheets file with 'Date' and 'Goal' in 2 columns) and the one on top linked to your actual number - this will then give the appearance of a goal chart, and will update dynamically.

 

Hope that helps,

Ben

bullet chart - goal and ranges from data

Follower ✭ ☆ ☆
# 3
Follower ✭ ☆ ☆

Hi,

 

That is a neat trick which should work well for what I have in mind!

 

Big thanks to you @Ben!

 

Have a nice evening and a lovely hollidays.

 

Best regards,

Per-Erik

bullet chart - goal and ranges from data

Visitor ✭ ✭ ✭
# 4
Visitor ✭ ✭ ✭

Hello @Ben!
Could you please upload an image of the solution? I do not understand what you are suggesting

Re: bullet chart - goal and ranges from data

Explorer ✭ ✭ ✭
# 5
Explorer ✭ ✭ ✭

Hi @Monica S

 

Sure thing, here is the final result:

 Capture.PNG

And here shows how you have one chart floating above another to achieve this:

 

Capture2.PNG

 

You can also do this with vertical bar charts, if you prefer.

 

Hope that helps,

Ben

bullet chart - goal and ranges from data

[ Edited ]
Explorer ✭ ✭ ✭
# 6
Explorer ✭ ✭ ✭

If it may be helpful to anyone else wanting to replicate this, I've written up a more detailed walkthrough of the process which you can read here:

‘Bullet charts’ with a dynamic goal in Google Data Studio

 

Ben

bullet chart - goal and ranges from data

Visitor ✭ ✭ ✭
# 7
Visitor ✭ ✭ ✭

Hey Ben,

 

Is your website currently un-operational?

 

Shiv

bullet chart - goal and ranges from data

Explorer ✭ ✭ ✭
# 8
Explorer ✭ ✭ ✭