Mouse over tooltip display in charts

[Frankximus]

Hey guys,

I'm doing a scattered plot by group chart in excel to be used in a powerpoint presentation. The reason is that originally I have an infographic live from infogr.am but I can't seem to embed/use it in powerpoint, so I'm using a workaround to create something similiar in excel.

I'm working on a few functions here:

1. For dots in the scatter plot, I'm working on giving them different colours for each of the 5 categories - Not solved yet
2. For each of the dot, when I hover my mouse over them in presentation mode, more details can pop up, like region/revenue/cost - Not solved yet

I've created all of these in infographic chart only to find that I can't use them in PPT. Can anyone give me some hints please?

Thanks heaps!

 

[thisoldman]

For point one, each of the different colors should be a different series. Excel gives each series a different color.

Point 2, I think, requires either VBA, or animation. I don't have the skills to help you there.

Often, the easiest way for me to work with an Excel workbook inside Powerpoint is to embed Excel within PPT:

In PPT, on a new slide, go to the ribbon's INSERT tab. Select Object then select either "Microsoft Excel Chart" or "Microsoft Excel Worksheet". A new workbook will be embedded in your slide. The PPT ribbon disappears and is replaced with the Excel ribbon. Clicking outside the Excel area on the slide returns you to Powerpoint; the Excel area now appears as a PPT graphic. From PPT, double-clicking on the graphic on the Excel area returns you to the Excel worksheet.

 

[Frankximus]

For point one, each of the different colors should be a different series. Excel gives each series a different color.

Point 2, I think, requires either VBA, or animation. I don't have the skills to help you there.

Often, the easiest way for me to work with an Excel workbook inside Powerpoint is to embed Excel within PPT:

In PPT, on a new slide, go to the ribbon's INSERT tab. Select Object then select either "Microsoft Excel Chart" or "Microsoft Excel Worksheet". A new workbook will be embedded in your slide. The PPT ribbon disappears and is replaced with the Excel ribbon. Clicking outside the Excel area on the slide returns you to Powerpoint; the Excel area now appears as a PPT graphic. From PPT, double-clicking on the graphic on the Excel area returns you to the Excel worksheet.

Hey mate, thanks for your reply.

I worked out the first one today, and now working towards giving comments to the dot points in the matrix (assuming it's not hard).

For the second, it seems that infographics are really meant to be in web pages, not powerpoint, so I've given up...

Thanks a lot for your reply!