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?
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.
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.
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