Dear Andy, Thanks a lot.
From: excel-macros@googlegroups.com [mailto:excel-mac...@googlegroups.com] On Behalf Of Aindril De Sent: Friday, June 12, 2009 5:38 AM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Re: HELP ON CHART PREPARATION Dear Vivek, This can be done using Pivot Table Chart. Please find attached the solution. Let me know if it helps. Regards, Andy On Thu, Jun 11, 2009 at 8:08 PM, vivek jain <vivek.j...@gmail.com> wrote: 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>>