This is a migrated thread and some comments may be shown as answers.

Custom tooltips - not templates, and overlaid charts

0 Answers 71 Views
Charts
This is a migrated thread and some comments may be shown as answers.
Paul
Top achievements
Rank 1
Paul asked on 07 Aug 2012, 01:31 PM
I'm sure these have both been asked, but I do not see a way to search your forums.

I am looking to show a bar chart of "sales" over a six month period.  So there are six vertical bars.  Each month also has a goal.  The goal is defined as the sum of each employee's personal goal.  So If I had two employees in Month 1, and their goals were $100,000, then the goal is $200,000.  In month 3 I add a new employee with a goal of $120,000 and now the goal is $320,000.

To help show this, I want to setup my chart as follows:
  1) Six vertical bar charts with [Jan/Feb/Mar....] underneath.
  2) A plotted point on the chart above or inside these bars indicating the goal for that month.
  3) A tooltip on the bars themselves like "$205,302.02 in sales".
  4) A tooltip on the indicators showing "$200,000 goal between 2 employee(s)"

So, the questions are:
#1 and #2 are easy, but I cannot figure out how to do these together.
# 3 is easy as it uses a template.  But I cannot figure out #4.  There's no template to show "2 employees" unless "2" is part of a data array, and if it is part of a data array, how can I use it in a tool tip and not show it on the chart otherwise?

No answers yet. Maybe you can help?

Tags
Charts
Asked by
Paul
Top achievements
Rank 1
Share this question
or