+ Reply to Thread
Results 1 to 9 of 9

Column Chart Doesn't Show The Data Series

  1. #1
    Forum Contributor
    Join Date
    01-16-2015
    Location
    Istanbul
    MS-Off Ver
    Office 365
    Posts
    922

    Column Chart Doesn't Show The Data Series

    Resource data is on the range V1:Y13.

    The column x has the ratio values. The column y has the top limit. 100%

    3% does not exist on the column chart on the right.

    It only shows the 100 parts. And It shows them as 10.000% not 100% too.

    How can I fix it?
    Attached Files Attached Files

  2. #2
    Forum Contributor
    Join Date
    10-30-2019
    Location
    Bistrita, Romania
    MS-Off Ver
    2019; 365
    Posts
    231

    Re: Column Chart Doesn't Show The Data Series

    Under Format Axis options, you should have Minimum = 0,0, Maximum = 1,2 since under Number you set the Percentage category.

    Also in column Y you should have 1 all the way down. If you want 100 then format Y1:Y13 as percentage.
    To show your appreciation
    Click ★ Add reputation!

  3. #3
    Forum Expert KOKOSEK's Avatar
    Join Date
    08-03-2018
    Location
    Pole in Yorkshire, UK
    MS-Off Ver
    365/2013
    Posts
    2,737

    Re: Column Chart Doesn't Show The Data Series

    Check max value for scale for right chart. Max have to be set as 1 (100%). Then 3% will be shown.
    Happy with my answer * Add Reputation.
    If You are happy with solution, please use Thread tools and mark thread as SOLVED.

  4. #4
    Forum Contributor
    Join Date
    01-16-2015
    Location
    Istanbul
    MS-Off Ver
    Office 365
    Posts
    922

    Re: Column Chart Doesn't Show The Data Series

    Where is that?

  5. #5
    Forum Expert KOKOSEK's Avatar
    Join Date
    08-03-2018
    Location
    Pole in Yorkshire, UK
    MS-Off Ver
    365/2013
    Posts
    2,737

    Re: Column Chart Doesn't Show The Data Series

    Is that what you expect?

    Capture.JPG


    Check attached file.
    Attached Files Attached Files

  6. #6
    Forum Contributor
    Join Date
    01-16-2015
    Location
    Istanbul
    MS-Off Ver
    Office 365
    Posts
    922

    Re: Column Chart Doesn't Show The Data Series

    Thank you very much. It works.
    Last edited by zanshin777; 10-12-2020 at 10:52 AM.

  7. #7
    Forum Guru
    Join Date
    04-13-2005
    Location
    North America
    MS-Off Ver
    2002/XP and 2007
    Posts
    15,802

    Re: Column Chart Doesn't Show The Data Series

    It only shows the 100 parts. And It shows them as 10.000% not 100% too.
    This is basic "how to convert from fraction to decimal to percent" stuff. The number 100 expressed as a percent is 10000%. If you need a refresher on how to convert between decimal and percent, this may help: https://www.purplemath.com/modules/percents.htm

    If I guess at what you want, I think you want a stacked column chart that shows the fractions in column X as the first "bottom" series in each stacked column. The remainder of each stacked column up to 1 (100%) is the second series. If my guess is correct, I entered =1-X1 into Y1 and copied down. No other edits seemed necessary.

    Did I guess right?
    Quote Originally Posted by shg
    Mathematics is the native language of the natural world. Just trying to become literate.

  8. #8
    Forum Contributor
    Join Date
    01-16-2015
    Location
    Istanbul
    MS-Off Ver
    Office 365
    Posts
    922

    Re: Column Chart Doesn't Show The Data Series

    Thank you very much MrShorty. We fixed it.

  9. #9
    Forum Expert KOKOSEK's Avatar
    Join Date
    08-03-2018
    Location
    Pole in Yorkshire, UK
    MS-Off Ver
    365/2013
    Posts
    2,737

    Re: Column Chart Doesn't Show The Data Series

    Quote Originally Posted by zanshin777 View Post
    Thank you very much. It works.
    Happy to help.
    Thanks for rep.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Chart - Stacked column from one data series
    By vicky464 in forum Excel Charting & Pivots
    Replies: 4
    Last Post: 11-05-2019, 12:25 AM
  2. How to create show or hide the data series in Scatter Chart
    By anandltvs in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 04-26-2015, 12:00 PM
  3. How to create show or hide the data series in Scatter Chart
    By anandltvs in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 04-26-2015, 10:50 AM
  4. Hard-coded Chart Series names show up blank until I paste data?
    By jimojimo in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 06-14-2014, 05:54 AM
  5. [SOLVED] data series doesn't show up on chart
    By chemeng1T3 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-10-2012, 10:03 AM
  6. Replies: 5
    Last Post: 06-21-2012, 10:12 AM
  7. Embedded Chart doesn't show data value on treadline.
    By Moses in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 01-05-2006, 12:40 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1