+ Reply to Thread
Results 1 to 9 of 9

Add secondary column graph to existing line graph

  1. #1
    Registered User
    Join Date
    06-25-2010
    Location
    Toronto, Canada
    MS-Off Ver
    Excel 2003
    Posts
    34

    Add secondary column graph to existing line graph

    I have a graph that displays daily production. There are 2 shifts a day, so the graph has 14 different data points. There is also a constant target line.

    Since the graph gets updated twice per day (at the end of each shift) I want to add a column graph on the right hand side showing the total production compared to the target. For example, if I have a target of 5 every shift, the total target for the week is 5*14 = 70. And if so far I have produced 4 and 2 on the first day and 5 and 3 on the second day, the total produced is 4+2+5+3 = 14. I want to add a column graph on the right side on a secondary axis showing the two values (14 and 70).

    Any idea how to do this?

    I attached a picture of the graph I have now.

    Thanks.
    Attached Images Attached Images
    Last edited by nbuk; 09-02-2010 at 10:29 AM.

  2. #2
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    20,419

    Re: Add secondary bar graph to existing line graph

    can you post example file so we can see your current data layout
    Cheers
    Andy
    www.andypope.info

  3. #3
    Registered User
    Join Date
    06-25-2010
    Location
    Toronto, Canada
    MS-Off Ver
    Excel 2003
    Posts
    34

    Re: Add secondary column graph to existing line graph

    Sorry its for work so I cannot post an example. I mean that I need a column graph not bar graph. I just need to know how to add it on a secondary axis and then get rid of that axis.

    Hope this makes sense.

  4. #4
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    20,419

    Re: Add secondary column graph to existing line graph

    do you mean you can not post attachments from work or you can not be bother to make an EXAMPLE file? We are only interested in the layout of data.

    Extend the current data points used in the lines by 2 data points.
    Add 2 extra data series with only the last data point populated.
    Move the 2 new series to the secondary axis.

  5. #5
    Registered User
    Join Date
    06-25-2010
    Location
    Toronto, Canada
    MS-Off Ver
    Excel 2003
    Posts
    34

    Re: Add secondary column graph to existing line graph

    The file is large and is intertwined across several sheets. It would take some time to create an example file. I will try your suggestion and if I cannot get it to work I will create a sample file.

    Thank you.

  6. #6
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    20,419

    Re: Add secondary column graph to existing line graph

    See attached, using my data layout.
    Attached Files Attached Files

  7. #7
    Registered User
    Join Date
    06-25-2010
    Location
    Toronto, Canada
    MS-Off Ver
    Excel 2003
    Posts
    34

    Re: Add secondary column graph to existing line graph

    I have created my sample file. I think my issue is that due to the layout of my data, my target line had to be formatted on a secondary axis.

    Also, all my production values are all on separate sheets in the original file.

    The target needs to be entered in just one cell for ease of updating (it changes each week)

    Is this still possible?
    Attached Files Attached Files
    Last edited by nbuk; 09-02-2010 at 11:18 AM.

  8. #8
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    20,419

    Re: Add secondary column graph to existing line graph

    this uses a single point xy-scatter and error bar to draw the benchmark line on the primary axis based on a single value.
    Attached Files Attached Files

  9. #9
    Registered User
    Join Date
    06-25-2010
    Location
    Toronto, Canada
    MS-Off Ver
    Excel 2003
    Posts
    34

    Re: Add secondary column graph to existing line graph

    Thanks! works great!

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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