scatter chart format

[alec1982]

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,

[alec1982]

That is a nice solutiion but if I do that the end user will have wrong expense nrs when they hyper in the mouse on top of the red dot.

The expenses in this case will be wrong.

Thxs,

Alec

[#3 · Accepted solution]

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

[alec1982]

Thank you Erica!