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 <[email protected]> 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... > > [image: cid:[email protected]] 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 [email protected] If you find any spam message in the group, please send an email to: Ayush Jain @ [email protected] or Ashish Jain @ [email protected] ------------------------------------------------------------------------------------- -~----------~----~----~----~------~----~------~--~---
<<inline: image002.jpg>>
<<inline: image001.gif>>
Vivek.xlsx
Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
