+ Reply to Thread
Results 1 to 3 of 3

How to properly chart this

  1. #1
    Forum Contributor
    Join Date
    05-30-2014
    Posts
    112

    How to properly chart this

    I would like to chart the attached data using a bar graph with Sections totals and Jobs totals by month along the X axis according to the left Y axis, and MS totals as a line graph to the right Y axis. I understand I could rearrange my data to make this easier but as I will be using this template many times I would rather not. any help would be appreciated.

    thanks
    BD

    Graph Example.xlsx

  2. #2
    Spammer
    Join Date
    01-26-2010
    Location
    Worcester MA
    MS-Off Ver
    Excel 2003
    Posts
    184

    Re: How to properly chart this

    Set up a linked table further to the right of this worksheet or in a second worksheet, where the linked table has columns rearranged to make charting work properly, and make your chart from this linked table.
    Jon Peltier
    http://PeltierTech.com/

  3. #3
    Forum Contributor
    Join Date
    05-30-2014
    Posts
    112

    Re: How to properly chart this

    yeah that's what I was figuring, was trying to get it down without doing that, but if that's what I have to do then so be it, not the biggest of deals

    thanks

+ 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. Gantt Chart Not Working Properly
    By kkundra in forum Excel General
    Replies: 1
    Last Post: 11-05-2014, 06:35 PM
  2. Range not feeding properly into chart
    By msantucci in forum Excel Charting & Pivots
    Replies: 4
    Last Post: 07-12-2014, 08:23 PM
  3. [SOLVED] Chart is not working properly
    By K m in forum Excel Charting & Pivots
    Replies: 4
    Last Post: 04-29-2013, 01:16 PM
  4. [SOLVED] VBA not properly formatting pie chart
    By Kaziglu Bey in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-21-2012, 02:57 PM
  5. Chart axis not autoscaling properly
    By ChemistB in forum Excel Charting & Pivots
    Replies: 4
    Last Post: 07-02-2010, 11:47 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