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
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?
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
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!
