Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I have a scatter chart that show sum expenses per location.
I have set the chart to have two colors red and blue. like if the expenses are in 2012 then show it in red otherwise keep it blue.
Now the dots in blue are good size and nice looking but the dots in red are too small.
Is there anyway i can maximize the red dots to be bigger.
Thxs,
Your welcome - did you know you can add a 4th expression that will act just as the pop up text to solve this problem.
First, go into the presentation tab in the chart properties and uncheck "pop up labels" to swith off any automated pop up displays.
Then add a 4th expression to the list that evaluates to whatever it is you wish to pop up when you hover over a bubble.
EG
='Year: ' & [Financial Year] & '
Total expenses:' & sum(Expenses)
Under display options, check the "Text as Pop-up" box.
When you hover over a bubble, the pop up will read:
Year: 2012
Total expenses: 10,000
For example.
Regards,
Erica
View solution in original post
go to chart properties -> presentation -> remove autosize symbol and increase the max bubble size
Thxs, but that would increase both of them. the red and blue.
Is there anyway I can maximize it when year = 2012.
Like thi is the method I use for having the two colors.
IF([Year Occupancy Acquisition] = '2012' , argb(255, 238, 49, 36), // Red
argb(155, 0, 147, 208) // Light Blue
Is there anyway to play with the size of the red dots only.
Thxs for your help.
I tired to use the dimenssion in the expression hoping that will return the same size but it didnt!
can you please share your application and see how i can help you ?
Hi Alec
Your scatter chart will have 2 expressions, 1 for x axis and 1 for y-axis. A third expression will set the bubble size. So
Set this in an if statement eg if(year = '2012',10,5)
the bubble size depend on you expenses
if amunt is big then bubble size will be larger and vice versa
hope this help
Erica,
Thanks for the reply.
The expression that measure the bubbles is Sum(Expenses.)
Would you please give me more details on how it should be written according to your If statement.
Thanks,
Alec,
If you would like the 2012 expenses to be bigger, I would multiply the sum(expenses) by some factor for those only.
So the third expression might read something like:
=if(Expense_Year = '2012',sum(Expenses)*10,sum(expenses))
This will increase the size of the red 2012 bubbles but still make them propotionally bigger dependant on the total expenses.
Is this what you are trying to achieve?
regards,
