S
Stephen Frith
For several years I have had an idea for an exciting development to charting
in general, and specifically applying it to excel. I have often thought of
writing a plug-in but have finally accepted that I will never get around to
it so I throw the idea into the community for someone else to run with:
The idea is straight-forward; create another dimension to the ranges
selected for a chart (time being the most obvious but any dimension would
work) and create multiple instances of the original two or three dimensional
chart, using the exact smae formatting. Then, when viewing, have a 'play'
button that animates the chart by refreshing the sequence.
A practical example would be to set up a two dimensional bar chart showing
sales by team for a given month. The full twelve months of data could then
be selected as the 'dynamic' range so that when 'play chart' is selected, the
graph flicks through all twleve months giving an animated view of shifting
perfomance throughout the year.
Many examples can be explored - rainfall by country by month; population by
country by year etc. etc.
The key is to draw the chart once, then select the additonal data that is in
the same shape for multiple, underlaying charts.
And of course to develop the necessary langauge to describe the new feature:
'Dynamic charting, animated charts, 4 dimensional charts' etc. etc.
I look forward to importing just such a chart into a powerpoint presentation
in the near future.
Many thanks and good luck
----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.
http://www.microsoft.com/office/com...b624632ef2&dg=microsoft.public.excel.charting
in general, and specifically applying it to excel. I have often thought of
writing a plug-in but have finally accepted that I will never get around to
it so I throw the idea into the community for someone else to run with:
The idea is straight-forward; create another dimension to the ranges
selected for a chart (time being the most obvious but any dimension would
work) and create multiple instances of the original two or three dimensional
chart, using the exact smae formatting. Then, when viewing, have a 'play'
button that animates the chart by refreshing the sequence.
A practical example would be to set up a two dimensional bar chart showing
sales by team for a given month. The full twelve months of data could then
be selected as the 'dynamic' range so that when 'play chart' is selected, the
graph flicks through all twleve months giving an animated view of shifting
perfomance throughout the year.
Many examples can be explored - rainfall by country by month; population by
country by year etc. etc.
The key is to draw the chart once, then select the additonal data that is in
the same shape for multiple, underlaying charts.
And of course to develop the necessary langauge to describe the new feature:
'Dynamic charting, animated charts, 4 dimensional charts' etc. etc.
I look forward to importing just such a chart into a powerpoint presentation
in the near future.
Many thanks and good luck
----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.
http://www.microsoft.com/office/com...b624632ef2&dg=microsoft.public.excel.charting