+ Reply to Thread
Results 1 to 5 of 5

Need to add 2nd series or 2nd y-axis to stacked bar chart...

  1. #1
    Forum Contributor
    Join Date
    08-06-2018
    Location
    Virginia
    MS-Off Ver
    2019
    Posts
    208

    Need to add 2nd series or 2nd y-axis to stacked bar chart...

    Experts:

    I need some assistance with modifying/tweaking a stacked bar chart by adding, e.g., another data series or a 2nd y-axis to the chart.

    Please see attached XLS for details... below summarizes the information.

    I'd appreciate any help w/ updating the stacked bar chart.

    Thank you,
    EEH

    *******Additional information **************


    Tab "Version 1":

    I need some assistance with modifying the stacked bar chart. Here's what I currently have in "Version 1".

    - I have 8 "State" values (CA, DE, FL, ..., ..., TX)... see row #1.
    - Each state value has data for both "6-years" and "1-year"... see row #2.
    - Finally, I then have percentage values for both "No" and "Yes"

    Here's what I need to achieve:
    - I want to apply the blue/orange color coding across the stacked bars
    - That is for the 6-Year values, I'd like to apply a light blue for 'yes' values AND dark blue for 'no' values.
    - Similarly, for the 1-Year values, I'd like to apply a light orange for 'yes' values AND dark orange for 'no' values.

    Here's the problem:
    - At this time, I can only chose 2 colors (for yes/no) but I cannot distinguish between the 6-year and 1-year values (via color-coding).

    Next steps:
    - I copied tab "Version 1" and created a 2nd tab "Version 2".
    - Please switch to tab "Version 2" to continue...


    Tab "Version 2":

    - Based on the information listed on tab "Version 1", I now have split up the two data ranges.
    - My thought was that I merely add additional "Data Series" to the chart.

    Here's the problem though... adding the following data series only creates a 3rd and 4th stack on the existing bars.

    My question: How can I combine all of the data in A3:I5 AND K3:S3 into one and the same stacked bar chart while allowing me to use different colors (2 blue shades tones and 2 orange shaded tones) for the 6-year and 1-year range?
    Attached Files Attached Files

  2. #2
    Forum Guru
    Join Date
    04-13-2005
    Location
    North America
    MS-Off Ver
    2002/XP and 2007
    Posts
    12,881

    Re: Need to add 2nd series or 2nd y-axis to stacked bar chart...

    It looks to me like you want a "clustered and stacked" column chart (see full tutorial here: https://peltiertech.com/clustered-st...mn-bar-charts/ ). In Version 1, I:

    1) Select C3:C4 -> Cut -> select C6 -> paste. Repeat for each 1 yr set.
    2) Select the chart -> bring up the Select Data dialog -> Add two new series and have them use row 6 and row 7 for values.
    3) Format the 4 data series as desired.

    Will that work for you?
    Quote Originally Posted by shg
    Mathematics is the native language of the natural world. Just trying to become literate.

  3. #3
    Forum Contributor
    Join Date
    08-06-2018
    Location
    Virginia
    MS-Off Ver
    2019
    Posts
    208

    Re: Need to add 2nd series or 2nd y-axis to stacked bar chart...

    Mr. Shorty:

    Yes, I think the presented charts on that URL will work for me...

    I couldn't seem to follow the direction provided in your steps 1:3.

    Appreciate any assistance w/ tweaking the chart to mimic what's presented in the "Clustered and Stacked" charts.

    Thank you in advance!
    EEH

  4. #4
    Forum Guru
    Join Date
    04-13-2005
    Location
    North America
    MS-Off Ver
    2002/XP and 2007
    Posts
    12,881

    Re: Need to add 2nd series or 2nd y-axis to stacked bar chart...

    Step 1 is just cut/paste/move step where I moved the 1 year data down 3 rows. Step 2 is adding two new data series to the chart (from your OP it seemed you were already familiar with ways to add data series to a chart -- choose your favorite method if my use of the Select Data dialog is confusing). Step 3 is just formatting, and you seem to already be familiar with how to format data series. Which step is causing your trouble? Are you having trouble moving the data, or adding data series to the chart?

  5. #5
    Forum Contributor
    Join Date
    08-06-2018
    Location
    Virginia
    MS-Off Ver
    2019
    Posts
    208

    Re: Need to add 2nd series or 2nd y-axis to stacked bar chart...

    Mr. Shorty - excellent... I was able to now follow along.

    The graph came out as desired... 'appreciate your help/tip on this subject.

+ 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. Replies: 3
    Last Post: 04-09-2018, 10:42 AM
  2. Replies: 5
    Last Post: 01-07-2017, 03:17 PM
  3. Replies: 0
    Last Post: 07-09-2015, 06:21 AM
  4. Stacked bar chart with stacked secondary axis markers - please help!
    By Boardlady in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 07-22-2013, 10:32 AM
  5. Replies: 1
    Last Post: 05-30-2013, 10:03 AM
  6. Stacked bar for multiple series + secondary axis
    By gilbertcn in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 10-25-2005, 03:05 AM
  7. Replies: 0
    Last Post: 02-11-2005, 11:40 AM

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