want to make dynamic chart
Hi
I wish to make dynamic chart of attached file, in same sheet.something like dashboard
| Attachment | Size |
|---|---|
| Book1.xls | 18.5 KB |
ExcelExperts.com
Excel Consultancy, VBA Consultancy, Training and Tips Call:+442081234832
ExcelExperts.comExcel Consultancy, VBA Consultancy, Training and Tips Call:+442081234832 |
|
Excel / VBA ConsultancyFree Training VideosFree SpreadsheetsExcel / VBA JobsNavigationWho's onlineThere are currently 0 users and 691 guests online.
New Excel Experts
Current Excel / VBA Jobs |
want to make dynamic chartHi I wish to make dynamic chart of attached file, in same sheet.something like dashboard
|
Highest Ranked Users
Recent Blogs
ForumsRecent comments
User login |
It depends on what you want
What would you like to show by dashboard. I suggest creating COUNTIF and SUMIF formula. Try to use Data Validation list containing "Apparel" and "Home Décor" as criteria for COUNTIF and SUMIF. Chart should reflect selected data. Something like that?