Hello! Is there a way to produce graphics like this with Excel?

%3CLINGO-SUB%20id%3D%22lingo-sub-917932%22%20slang%3D%22en-US%22%3EHello!%20Is%20there%20a%20way%20to%20produce%20graphics%20like%20this%20with%20Excel%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-917932%22%20slang%3D%22en-US%22%3E%3CP%3EHello!%20Is%20there%20a%20way%20to%20produce%20graphics%20like%20this%20with%20Excel%3F%20%3CLI-EMOJI%20id%3D%22lia_slightly-smiling-face%22%20title%3D%22%3Aslightly_smiling_face%3A%22%3E%3C%2FLI-EMOJI%3E%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fwww.youtube.com%2Fwatch%3Fv%3DF8Bpt9sXN7Y%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fwww.youtube.com%2Fwatch%3Fv%3DF8Bpt9sXN7Y%3C%2FA%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1022389%22%20slang%3D%22en-US%22%3ERe%3A%20Hello!%20Is%20there%20a%20way%20to%20produce%20graphics%20like%20this%20with%20Excel%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1022389%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F428212%22%20target%3D%22_blank%22%3E%40mattiapaoli%3C%2FA%3E%26nbsp%3Bthanks%20for%20you%20interest%20in%20Excel%20charting.%3C%2FP%3E%0A%3CP%3EWe%20sometimes%20refer%20to%20this%20concept%20you%20are%20showing%20as%20a%20%22Play%20Axis%22%20which%20allow%20you%20to%20show%20multiple%20dimensions%20of%20your%20data%20changing%20over%20time.%26nbsp%3B%20At%20the%20moment%20there%20is%20no%20default%20built-in%20way%20to%20give%20charts%20a%20Play%20Axis.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EIt%20is%20possible%20to%20spoof%20some%20this%20concept%20using%20formulas%20to%20pull%20a%20particular%20subset%20of%20data%20(say%201%20particular%20year%20from%20a%20table%20of%20years)%20and%20VBA%20to%20cycle%20through%20which%20specific%20subset%20of%20data%20is%20pulled.%26nbsp%3B%20This%20doesn't%20give%20as%20clean%20a%20view%20of%20some%20of%20the%20movement%2C%20but%20gets%20near%20the%20idea.%26nbsp%3B%20We'd%20love%20to%20hear%20from%20users%20if%20supporting%20a%20play%20axis%20is%20desirable.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-center%22%20style%3D%22width%3A%20999px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F158147iC951A86996CCB157%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%222019-11-20_12-13-48.gif%22%20title%3D%222019-11-20_12-13-48.gif%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1103180%22%20slang%3D%22en-US%22%3ERe%3A%20Hello!%20Is%20there%20a%20way%20to%20produce%20graphics%20like%20this%20with%20Excel%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1103180%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F162%22%20target%3D%22_blank%22%3E%40Johnnie%20Thomas%3C%2FA%3EThanks%20Johnnie%20for%20the%20answer!%20That's%20very%20cool.%20A%20%22smooth%22%20movement%20in%20the%20chart%20would%20be%20lovely%2C%20but%20I%20understand%20that's%20not%20the%20main%20purpose%20of%20Excel%20%3CLI-EMOJI%20id%3D%22lia_slightly-smiling-face%22%20title%3D%22%3Aslightly_smiling_face%3A%22%3E%3C%2FLI-EMOJI%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1103205%22%20slang%3D%22en-US%22%3ERe%3A%20Hello!%20Is%20there%20a%20way%20to%20produce%20graphics%20like%20this%20with%20Excel%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1103205%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F428212%22%20target%3D%22_blank%22%3E%40mattiapaoli%3C%2FA%3E%26nbsp%3BI%20am%20not%20an%20expert%20in%20Power%20Point%20but%20I%20think%20It%20can%20be%20done%2C%20even%2C%20without%20VBA%20with%20Power%20Point%20if%20you%20play%20with%20slides%20and%20transitions.%3C%2FP%3E%3CP%3EI%20think%20that%20the%20thick%20is%20creating%20a%20slide%20by%20year%2C%20by%20month%2C%20by%20week...%3C%2FP%3E%3CP%3EFind%20out%20about%20Morph%20Transitions%20in%20Power%20Point.%3C%2FP%3E%3CP%3EI%20have%20tested%20it%20and%20can%20create%20same%20effect%20but%20with%20lot%20of%20work...%20every%20bar%20must%20be%20in%20a%20separate%20image...%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2139650%22%20slang%3D%22en-US%22%3ERE%3A%20Hello!%20Is%20there%20a%20way%20to%20produce%20graphics%20like%20this%20with%20Excel%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2139650%22%20slang%3D%22en-US%22%3EHI%20Mattia%2C%20yes%20I%20think%20this%20dynamic%20chart%20can%20be%20replicated%20in%20Excel%20online%20using%20Office%20Scripts.%20I%20cannot%20see%20any%20reason%20why%20it%20would%20not%20work.%3C%2FLINGO-BODY%3E
New Contributor

Hello! Is there a way to produce graphics like this with Excel?

https://www.youtube.com/watch?v=F8Bpt9sXN7Y

This video shows the top 10 manufacturers with the most units sold every year from 1992 to 2018-~-~~-~~~-~~-~-Watch: "Electric Cars Sold in the United States...
4 Replies

@mattiapaoli thanks for you interest in Excel charting.

We sometimes refer to this concept you are showing as a "Play Axis" which allow you to show multiple dimensions of your data changing over time.  At the moment there is no default built-in way to give charts a Play Axis.

 

It is possible to spoof some this concept using formulas to pull a particular subset of data (say 1 particular year from a table of years) and VBA to cycle through which specific subset of data is pulled.  This doesn't give as clean a view of some of the movement, but gets near the idea.  We'd love to hear from users if supporting a play axis is desirable.

 

2019-11-20_12-13-48.gif

 

@Johnnie ThomasThanks Johnnie for the answer! That's very cool. A "smooth" movement in the chart would be lovely, but I understand that's not the main purpose of Excel

@mattiapaoli I am not an expert in Power Point but I think It can be done, even, without VBA with Power Point if you play with slides and transitions.

I think that the thick is creating a slide by year, by month, by week...

Find out about Morph Transitions in Power Point.

I have tested it and can create same effect but with lot of work... every bar must be in a separate image... 

 

 

 

HI Mattia, yes I think this dynamic chart can be replicated in Excel online using Office Scripts. I cannot see any reason why it would not work.