ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)
-   -   EXCEL BAR CHART (https://www.excelbanter.com/charts-charting-excel/128195-excel-bar-chart.html)

jack cycle

EXCEL BAR CHART
 
I am trying to gind a template that I can use to show sales monthly compared
to last year's monthly

Thanks

Jon Peltier

EXCEL BAR CHART
 
Sounds to me like you just need a clustered column chart.

2007 2006
Jan xxxx xxxx
Feb xxxx xxxx
Mar xxxx xxxx
etc.

Note that the top left cell is blank; fight the urge to put a label like
"Month" there, as the blank cell helps Excel interpret your data. Select the
data, run the chart wizard, and choose a clustered column chart or a line
chart in step 1.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
http://PeltierTech.com
_______


"jack cycle" <jack wrote in message
...
I am trying to gind a template that I can use to show sales monthly
compared
to last year's monthly

Thanks





All times are GMT +1. The time now is 06:34 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com