Mimicing The Hans Rosling Presentation From TED
Jun 23, 2009Can I mimic the following in Excel?
http://www.ted.com/talks/hans_roslin...ever_seen.html
It can be done in Google Docs.
ADVERTISEMENT
Convert Excel Workbook To PPT Presentation?
Nov 22, 2013It says Compiled Error: User-defined type not defined.
Code below
Sub Macro101()
Dim pp As PowerPoint.Application
Dim PPPres As PowerPoint.Presentation
Dim PPSlide As PowerPoint.Slide
[Code].....
Presentation Of Multiple Results Of A Lookup
Aug 17, 2005I have some data arranged in columns/rows as follows:
Location Name
--------- ------
United States Sarah Buchannan
United States Walter Smith
France Phil Barney
Italy Anna Wilson
Germany Philip Watson
France Neil Anderson
I want to have some function in my spreadsheet that will neatly present the names of the people at a given location in a separate part of the worksheet
e.g. a display of all people in France would have something like:
France
-------
Phil Barney
Neil Anderson
Ideally I would like to populate cells rows in a different column with the multiple results of the lookup ("persons at a given location") and that change in location for any individual would result in the list of persons at a given location being automatically updated.
Did alot of digging around and managed to construct a UDF that would display the results of the lookup in a single cell - it is however not very readable. But, I found out that a cell based UDF is not allowed to populate other cells other that the one where the function is entered!
Table Presentation: Diagonal Line Splitting Two Values In One Column
Mar 4, 2007I have a table with data representing $income vs %Debt burden respectively. The data on the table per respective intersection provides number of accounts and total ($)value of accounts. I have tried to combine the two pieces of information into one column and have a diagonal line separating the two numbers. (sample table attached).
View 2 Replies View RelatedCustom Data Presentation From Raw Data
Oct 2, 2013Is there any add-in/tool that present data in a custom format?I have the following data:
A
B
C
D
1
Shipment
Driver
Customer
Order
2
S1
D1
C1
O1
[Code] .......
The desired output is:
Shipment
Driver
S1
D1
Customer
Order
[Code] ......