Maverick27
Active Member
- Joined
- Sep 23, 2010
- Messages
- 336
- Office Version
- 2013
- Platform
- Windows
Can somebody pls tell me how to 'HIDE' the 'DATE' component from 'X Axis' of the Graph & instead show it as a Bar with different colour ?
See imageshack link below.
http://img577.imageshack.us/i/excelgraph.jpg/
I want the 'BARs' on the Chart to show in different colours to signify the DATE Component.
Note: In the imageshack link, 'RED ARROW' points to FEB/11 Sales.
In short: I want the JAN/11 & FEB/11 Sales to show in diff. colour.
And also hide the DATE Text but show only the Product.
Link below shows snapshot of the DATA.
http://img6.imageshack.us/i/excele.jpg/
Thanks - Mave
See imageshack link below.
http://img577.imageshack.us/i/excelgraph.jpg/
I want the 'BARs' on the Chart to show in different colours to signify the DATE Component.
Note: In the imageshack link, 'RED ARROW' points to FEB/11 Sales.
In short: I want the JAN/11 & FEB/11 Sales to show in diff. colour.
And also hide the DATE Text but show only the Product.
Link below shows snapshot of the DATA.
http://img6.imageshack.us/i/excele.jpg/
Thanks - Mave