You are here:

Excel/bar, column,andline graphs and other matters


hello Mary, nice to "meet" you!

I use Windows 7 with Excel 2007 and Excel 2010.

First, the "other matters" in the Subject title...
My spreadsheet has two sets of data. Each set consists of a row of 52 weekly dates for 2011 and the corresponding row of sales in each of those weeks.
A  second set of data occupy another two rows, one of dates in 2012 and the other of sales.
I had no problem entering both sets of sales data in a graph, whether as lines or bars...The sales data are in the y axis.
I show the 2012 weekly dates in the X axis.

MY QUESTION: hOW can I show the 2011 dates in the graph?

Second item:
I want to adjust the width of the lines, bars, columns in their respective graphs. I want to be able to make them thinner or thicker.

Can you tell me how to do these tasks?

Thanks for your help.


Hi Chris,

Good to make your acquaintance as well.

To show the 2011 dates in a graph, you will select only the rows that you want to show in the graph.  Reminder:  You can select cells of data by holding down your Shift key to select cells that are adjacent to each other (contiguous) and CTRL key for those cells that are not adjacent (or non-contiguous).  

For the width adjustment of lines, bars and columns, try the following:

Right-click on one of the bars/lines/columns and choose 'Format Data Series'. In the Format Data Series window, on the Series Options tab (first tab) move the Gap Width slider closer to 'No Gap', which will widen each of the bars/lines/columns.

I hope this helps your project.

Good luck,

About Excel
This topic answers questions related to Microsoft Excel spreadsheet (or workbook) stand-alone or Mircrosoft Office Excel including Excel 2003, Excel 2007, Office 2000, and Office XP. You can get Excel help on Excel formulas(or functions), Excell macros, charting in Excel, advanced features, and the general use of Excel. This does not provide a general Excel tutorial nor the basics of using a spreadsheet. It provides specific answers to using Microsoft Excel only. If you do not see your Excel question answered in this area then please ask an Excel question here


All Answers

Answers by Expert:

Ask Experts


Mary A. Lindsey


I can answer Microsoft Excel 2000-2007 questions regarding formatting, styles, shortcut keys, templates, forms, etc, but will not answer any macro questions.


I have over 15 years experience working in corporate America as legal and financial document support specialist. I have designed a template that converts html and Excel files to inserts these numerical data into Word documents so that there will be no document corruption because of file size and graphics that comes as part of HTML and Excel.


I am a Microsoft Office Master Instructor (MOS), Certiport Administrator and Proctor (97-2003)

©2016 All rights reserved.