+ Reply to Thread
Results 1 to 3 of 3

Line Column Chart-how to adjust

  1. #1
    Registered User
    Join Date
    02-11-2007
    Posts
    12

    Question Line Column Chart-how to adjust

    I have a chart, which illustrates scores for business by quarter. I want the quarterly numbers to be shown in a bar,(4 bars) and the average variance to be shown as a line across the graph, with a second y axis. When I choose that chart type, the default gives me 3 bars, 2 lines, completely throwing off the chart. Any advice???

  2. #2
    Forum Expert Carim's Avatar
    Join Date
    04-07-2006
    Posts
    4,070
    Hi,
    Take a look at Jon's solution ...
    http://peltiertech.com/Excel/Charts/...nColChart.html
    HTH
    Carim


    Top Excel Links

  3. #3
    Registered User
    Join Date
    02-11-2007
    Posts
    12

    Close, but not quite

    I am attaching a sample of the chart. Everything needs to stay as it is, but I need a scatter line which will illustrate the variance, and a scale from 1-20 on the right side. (The variance would be 100-score).
    Attached Images Attached Images

+ 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