98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View Reviews
Forum home » Delegate support and help forum » Microsoft Excel Training and help » Relationship between different sections of data | Excel forum
Relationship between different sections of data | Excel forum
Resolved · Medium Priority · Version 2010
Fri 31 Jan 2014, 17:51Delegate Jagparvesh said...
Jagparvesh has attended:
No courses
Relationship between different sections of data
Which one of the following options is a visual representations of data from a worksheet or Excel table that displays the relationship between the different sections of data?
- Sparkline
- Link
- Illustration
- Chart
Fri 31 Jan 2014, 17:55Delegate Jagparvesh said...
RE: Relationship between different sections of data
SmartArt Graphic seems correct answer to me. If yes, then which specific SmartArt graphic type can do the following?
Also, I think chart may be a correct answer too. Doesn't it provide a visual representation of data?
Mon 3 Feb 2014, 16:14Trainer David said...
RE: Relationship between different sections of data
Hi Jagparvesh
SmartArt Graphic was not one of the original options suggested so I would suggest for that reason it is not the right response.
I believe a Chart is the correct answer.
Regards
David
Tue 4 Feb 2014, 12:14Trainer Simon said...
RE: Relationship between different sections of data
In agreement with David here: a Chart is the way to go.
Sparklines are mini-charts (they fit in one cell). They're linked to the data, but tiny.
Links are connections with other sheets, databases, etc. Thus they're a link to other data, not a display.
Illustrations: yes, you can use your own illustration, but it's a manual solution, and isn't linked with the data.
SmartArt is more capable than illustration, but it's still your 'manual' picture, rather than using the power of Excel!
Training information:
See also:
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Excel tip:DATEDIF functionThe DATEDIF function is a worksheet function that computes the difference between two dates. This function is documented only in the help files for Excel 2000. It isn't documented in Excel 2002. |
