Getting the graph style I want

Discussion in 'Excel' started by highstream, Dec 5, 2016.

  1. highstream

    highstream

    Joined:
    Oct 6, 2015
    Messages:
    9
    Likes Received:
    0
    In Home & Student 2010, I just switched an Excel graph of 2016 daily data to weekly averages. It's a line graph with markers, but right now there is no line just relatively large square markers. I have some questions:

    - How do I get a line?

    - How do I change the size and shape of the markers to something like small dots?

    - The vertical axis right now is 0 to 250, but all the data (will) fall within a limited range, say, 150-200, so the graph is currently visually compressing the data. How do I change the the graph vertical axis to reflect a more limited range?

    Thanks,
     
    highstream, Dec 5, 2016
    #1
    1. Advertisements

  2. highstream

    Amy @ German Pearls

    Joined:
    Feb 2, 2016
    Messages:
    25
    Likes Received:
    9
    To get a line right click on one of the dots and select change chart type. (Or, you could click on the graph and click on the design tab of the new chart tools menu that appears at the top.) When the chart type menu opens click on line on the left portion, then select the picture that looks like the chart you want, probably the fourth one over.

    To change the size and shape of the marker right click on one of the dots or the line and select format data series. Then select marker options from the left side. Your editing options will appear on the right side. Use the dropdown next to type to change the shape. Select marker fill on the left to edit the color. Notice you can also change the color of the line if you select marker line color.

    To change the axis range double click on the axis. Under axis options you can choose the min and max as well as how many units appear.

    Amy
     
    Amy @ German Pearls, Dec 6, 2016
    #2
    Becky likes this.
    1. Advertisements

  3. highstream

    highstream

    Joined:
    Oct 6, 2015
    Messages:
    9
    Likes Received:
    0
    Amy, Thanks for your quick reply. The latter two of your suggestions worked just great. The problem is with the first: as indicated in my OP and screenshots, the chart type I have chosen is line with markers, the fourth one across from the left, but as you can see from the screenshots, there's no line. What am I missing?

    Excel graph 1.JPG Excel graph 2.JPG
     
    highstream, Dec 6, 2016
    #3
  4. highstream

    Amy @ German Pearls

    Joined:
    Feb 2, 2016
    Messages:
    25
    Likes Received:
    9
    Hm, that's strange. Can you confirm the color isn't set to white?
    Also, if you click to a bar graph and then click back to the line - does it fix it?
     
    Amy @ German Pearls, Dec 9, 2016
    #4
  5. highstream

    highstream

    Joined:
    Oct 6, 2015
    Messages:
    9
    Likes Received:
    0
    Line Color: see screenshot
    bar graph and back --> no change

    Excel graph 3.JPG
     
    highstream, Dec 9, 2016
    #5
    1. Advertisements

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

You'll need to choose a username for the site, which only take a couple of moments (here). After that, you can post your question and our members will help you out.
Similar Threads
  1. palombo
    Replies:
    0
    Views:
    373
    palombo
    Jul 2, 2012
  2. krisdj
    Replies:
    0
    Views:
    507
    krisdj
    Sep 25, 2012
  3. asyluma
    Replies:
    0
    Views:
    484
    asyluma
    Oct 9, 2013
  4. highstream

    Getting a page break to take

    highstream, Oct 6, 2015, in forum: Excel
    Replies:
    0
    Views:
    263
    highstream
    Oct 6, 2015
  5. highstream

    Getting the formula right

    highstream, Nov 9, 2016, in forum: Excel
    Replies:
    5
    Views:
    213
    Amy @ German Pearls
    Nov 10, 2016
Loading...