MobileMobile | Continue

Excel Bar

Excel Bar

Your excel questions will be responsed by our excel experts within 24hrs.Our service is free.

 Forgot Pass?
 Register Now
Find
Hot Search: Vlookup Match VBA
View: 329|Reply: 3

Creating Dynamic Timeline in Powerpoint with data from Excel table.

[Copy link]

1

Topics

1

Posts

5

Integral

Newbie

Rank: 1

Integral
5
Post on 9-14-2016 18:30:14 | All posts |Read mode
Hello there,
I have been experimenting with creating timelines in Powerpoint using a plugin/extension called Office Timeline. I would like to know if there is any way (or graphically equivalent) to construct the timeline using data from excel in a dynamic way so that changes in my data are reflected in the timeline.
Thanks in advance,
Kostas
Reply

Props Report

11

Topics

130

Posts

283

Integral

Conqueror

Rank: 3Rank: 3

Integral
283
Post on 2-6-2017 14:26:21 | All posts



the simple formula












Reply Support Opposition

Props Report

3

Topics

11

Posts

37

Integral

Member

Rank: 2

Integral
37
Post on 2-6-2017 15:55:20 | All posts



patttti sab..its not working because of #VALUE!.
thanks for letting me now that its a simple formula




Reply Support Opposition

Props Report

13

Topics

1065

Posts

2355

Integral

King

Rank: 6Rank: 6

Integral
2355
Post on 2-6-2017 17:21:08 | All posts



What is the source of the #VALUE# error? My first thought would be to nest the current function in B so that it returns some kind of text string when it errors, then the sum function ImramBhatti suggested would work fine. Are you familiar with the IFERROR() function? https://support.office.com/en-us/art...6-63f3e417f611
Something like =IFERROR(current formula in B,error)
Reply Support Opposition

Props Report

Points policy of this forum

Archiver|Mobile|Small dark house|Contact us|Excel Bar

GMT-5, 11-20-2017 00:41 , Processed in 0.293185 second(s), 20 queries .

Powered by Discuz! X3

© 2001-2013 Comsenz Inc.

!fastreply! Top !return_list!