98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View Reviews
Forum home » Delegate support and help forum » Microsoft Excel Training and help » Organising chart data
Organising chart data
Resolved · Urgent Priority · Version 2003
Fri 25 Apr 2008, 12:50Delegate Simon said...
Simon has attended:
Dreamweaver 8 Introduction course
Access Intermediate course
Organising chart data
I need to create a chart which shows each month of the year on the x-axis and value on the y. I need to show several years on the chart, with each year being a different colour. I'm not sure how to arrange the data to enable this - ie how can I get the Jan 05, Jan 06, Jan 07 & Jan 08, Feb 05, Feb 06 and so on to overlay on one chart using just 12 months along the x-axis? Grateful for your advice, thanks, Simon
Fri 25 Apr 2008, 22:44
Edited on Fri 25 Apr 2008, 22:45Trainer Cress said...
RE: Organising chart data
Hi
You need to columns, the first is date, the second is value. Add the chart and right click on a bar to format the data series. On the options tab select the 'Varies colour by point option' to make each bar a different colour. Please find attached an example.
regards
Attached files...
Bar Chart Example.xls
Training information:
See also:
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Excel tip:Adding multiple rows in an Excel 2010 WorksheetIf you want to add more than one row to an Excel Worksheet, drag select the number or rows you want added to the spreadsheet. |
