column charts with set set of data

Discussion in 'Excel Charting' started by Tonso, Jun 19, 2013.

  1. Tonso

    Tonso Guest

    I have data that looks similar to this...

    Month Minutes % Loss
    March 151 9.2%
    April 196 12.7%
    May 188 12.9%
    June 142 8.30%


    I would like to display it in a column chart as follows

    Minutes would be displayed as a column that uses the primary axis.

    % Loss would also be displayed as a column and used the secondary axis.

    Both values for March would be displayed as columns,side by side, same for
    April, May, and June. When I try to do this the minutes and % losses are stacked on top of one another instead of side by side. is this doable?

    Thanks,

    Tonso
     
    Tonso, Jun 19, 2013
    #1
    1. Advertisements

Want to reply to this thread or ask your own question?

It takes just 2 minutes to sign up (and it's free!). Just click the sign up button to choose a username and then you can ask your own questions on the forum.
Similar Threads
  1. Ramu Rayapudi
    Replies:
    0
    Views:
    235
    Ramu Rayapudi
    Sep 22, 2004
  2. steve root

    Column charts with multiple data in each column

    steve root, Jun 22, 2005, in forum: Excel Charting
    Replies:
    1
    Views:
    107
    Tushar Mehta
    Jun 22, 2005
  3. t4gbg
    Replies:
    1
    Views:
    90
    Bernard Liengme
    Aug 22, 2005
  4. RohanSewgobind

    Matching the colors Column Charts and Pie Charts

    RohanSewgobind, Apr 21, 2006, in forum: Excel Charting
    Replies:
    3
    Views:
    733
  5. Shane Daniel

    Can you set dual axis side by side column charts?

    Shane Daniel, Aug 25, 2006, in forum: Excel Charting
    Replies:
    2
    Views:
    124
    Shane Daniel
    Aug 25, 2006
  6. Richard
    Replies:
    1
    Views:
    235
    Jon Peltier
    Oct 26, 2006
  7. Replies:
    4
    Views:
    196
    Jon Peltier
    Dec 28, 2006
  8. Sean
    Replies:
    2
    Views:
    186
Loading...