+ Reply to Thread
Results 1 to 2 of 2

Create mixed pie charts using the same base data structure

  1. 03-25-2018, 08:46 AM #1
    mpjames
    mpjames is offline
    Registered User
    Join Date
    03-25-2018
    Location
    UK
    MS-Off Ver
    2016
    Posts
    1

    Create mixed pie charts using the same base data structure

    Hi,
    I have a list of 5 categories and for each, a value of sales in 2016 and 2017.
    I can create a pie chart for 2016 data and an identical one using 2017 data. This means 2 pie charts, each with its own (identical) legend.

    Is it possible to create 2 x pie charts side by side with just one legend underneath and have them using the same table of data?

    Any pointers very gratefully received.

    Thanks,
    Matt

    Excel 2016 for Mac
    Reply With QuoteRegister To Reply
  2. 03-25-2018, 09:00 AM #2
    AliGW
    AliGW is online now
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (both in England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2504 (Windows 11 Home 24H2 64-bit)
    Posts
    90,695

    Re: Create mixed pie charts using the same base data structure

    Can't you just hide the legend on the second chart?
    Ali

    Enthusiastic self-taught user of MS Excel who's always learning!
    Don't forget to say "thank you" in your thread to anyone who has offered you help. It's a universal courtesy.
    You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
    NB:     as a Moderator, I never accept friendship requests.
    Forum Rules (updated August 2023): please read them here.
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Create a Table Structure from raw data
    By CIRHS in forum Excel General
    Replies: 2
    Last Post: 10-18-2016, 01:58 PM
  2. Create Data base and reports
    By udayg10 in forum Access Tables & Databases
    Replies: 1
    Last Post: 08-18-2016, 10:11 AM
  3. [SOLVED] create data base that link to report
    By sarahqputra in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 01-26-2015, 10:38 PM
  4. Excel 2007 : Help with Mixed and Variable width Charts
    By Excel_Monkey in forum Excel General
    Replies: 1
    Last Post: 02-21-2012, 08:04 AM
  5. Excel 2007 : Creating Macro's to Create Columns and turn change data structure
    By Hyflex in forum Excel General
    Replies: 1
    Last Post: 09-07-2010, 01:15 PM
  6. create new structure of data/info
    By jbulluck in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 07-08-2010, 04:18 PM
  7. I need to create a data base
    By Kernow1962 in forum Excel General
    Replies: 2
    Last Post: 08-06-2006, 12:05 PM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1