Dear All,
I want to prepare chart for the following data:- State Place % ot Total Sales Manipur Imphal 2.57% Meghalaya Jowai 12.94% Assam Margherita 0.42% Arunachal Pradesh Naharlagun 13.33% Assam Tezpur 0.44% Mizoram Aizwal 9.08% Meghalaya Byrnihat 2.00% Nagaland Dimapur 4.26% Assam Guwahati 1.60% Meghalaya Khliehriat 6.49% Manipur Manipur 17.79% Others Others 8.41% Meghalaya Shillong 6.11% Meghalaya Tura 14.54% The Chart should show one bar for each state and each bar should have different colours for each place based on % of sale ratio. Please let me know the steps to do the same . I am using Excel 2007. Thanks & Regards... cid:image001.jpg@01C85EB8.0483F790 Vivek Jain, FCA, DISA (ICAI) Vivek Shantilal Jain & Co. Chartered Accountants 3010 Ram Kumar Arcade, Chatribari Road, A T Road, Guwahati-781001 (0361-2603895,9435019908 --~--~---------~--~----~------------~-------~--~----~ ------------------------------------------------------------------------------------- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com ------------------------------------------------------------------------------------- -~----------~----~----~----~------~----~------~--~---
<<inline: image001.gif>>
<<inline: image002.jpg>>