VBA & Charts: How to make mouse hoverover event Values A Larger Font?

[CrunchMasterMatt]

I picked an excel Chart Style called: "Line With Markers"

The chart plots 3 data series points (the asterix's * shown below in the chart) representing 3 monthly payment amounts, over 3 years time.

The Horizontal Axis is Year 1, 2 & 3
The Vertical Axis is the Dollar Amount of the monthly payment.

The payment rises over time, so the chart looks like this:
------------------------------------------------------------------------------------
$100 | *
$50 | *
$0 | *
|__________________
Year 1 2 3

------------------------------------------------------------------------------------

If you 'mouse over' the data points in the chart (the asterix's * shown above) then you cause a default excel chart event to fire, which renders a tool tip looking shape with text inside of it rendering the exact Value of the Series Point. For example, it might be $52.37 in year 2, per the above chart example.

My question is: Can you make the Series Point hover shape text (which shows the monthly payment) any larger?

Thank You!!

 

[Worf]

Hi

You could use mouse related chart events to show any of the following objects with that information:

- A message box
- A user form with big, colorful text
- A shape with big, colorful text

This can be done for chart sheets or embedded charts. The page below is a comprehensive guide on this subject. Tell me if you need further help.

Chart Events in Microsoft Excel - Peltier Tech Blog

 

[CrunchMasterMatt]

Awesome, thank you! That seems like everything I will need to do the job!!