+ Reply to Thread
Results 1 to 4 of 4

Population Pyramid Formatissue

  1. 02-23-2015, 06:38 AM #1
    levtweeney
    levtweeney is offline
    Registered User
    Join Date
    05-13-2013
    Location
    Newcastle upon Tyne
    MS-Off Ver
    Excel 2010
    Posts
    36

    Population Pyramid Formatissue

    Hi All

    I have created a pyramid chart from the data in the attached spreadsheet.

    I am using columns B and D in the chart

    I need to make the Minus figures in chart just have the figures without the minus sign.

    Is this possible? and am I making sense?

    Thanks for any and all help

    Regards

    Lev
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  2. 02-23-2015, 06:46 AM #2
    Special-K
    Special-K is offline
    Forum Expert
    Join Date
    03-23-2004
    Location
    London, England
    MS-Off Ver
    Excel 2019
    Posts
    7,065

    Re: Population Pyramid Formatissue

    ABS() will turn a negative into a positive figure
    Regards
    Special-K

    Ensure you describe your problem clearly, I have little time available to solve these problems and do not appreciate numerous changes to them.
    Reply With QuoteRegister To Reply
  3. 02-23-2015, 06:50 AM #3
    samba_ravi
    samba_ravi is offline
    Forum Guru samba_ravi's Avatar
    Join Date
    07-26-2011
    Location
    Hyderabad, India
    MS-Off Ver
    Excel 2021
    Posts
    8,915

    Re: Population Pyramid Formatissue

    Select D2:D20
    Custom format Cells as #,##0;[Red]#,##0
    Attached Files Attached Files
    Samba

    Say thanks to those who have helped you by clicking Add Reputation star.
    Reply With QuoteRegister To Reply
  4. 02-23-2015, 06:52 AM #4
    samba_ravi
    samba_ravi is offline
    Forum Guru samba_ravi's Avatar
    Join Date
    07-26-2011
    Location
    Hyderabad, India
    MS-Off Ver
    Excel 2021
    Posts
    8,915

    Re: Population Pyramid Formatissue

    or simply change the number format as 1,234 Instead of -1,234
    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. [SOLVED] Population pyramid overlapping series question
    By rhysp in forum Excel Charting & Pivots
    Replies: 4
    Last Post: 07-09-2014, 07:49 AM
  2. Population Pyramid
    By bobisnotkee in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 01-04-2013, 11:28 PM
  3. How can population pyramid made in excel ?
    By prashant279 in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 05-13-2006, 08:10 PM
  4. [SOLVED] How do I create a population pyramid?
    By ian_s_mcd in forum Excel General
    Replies: 1
    Last Post: 10-24-2005, 11:05 AM
  5. how do you make a population pyramid for excel 03?
    By naeem in forum Excel General
    Replies: 0
    Last Post: 05-02-2005, 05:06 PM

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