The third chart which is below one is mine.
There, the data on the x Axis is different than others. As you see other charts have years as data of the x Axis.
How do I make it like those?
The third chart which is below one is mine.
There, the data on the x Axis is different than others. As you see other charts have years as data of the x Axis.
How do I make it like those?
Is this different from your other thread...
http://www.excelforum.com/excel-form...to-serial.html
?
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
Yes, it is different - this time you want to change the Data Source to point to your column of dates (years). Similar to before, click on the chart, then right-click and choose the Select Data option, then in the right-hand box where it says Horizontal Axis labels click Edit, then move the cursor to select the cells where your years are (i.e. =Sheet1!$B$4:$B$17), then click OK, and OK again. You might want to play about with Format Axis (see your other thread) to get the right font and alignment.
Hope this helps.
Pete
Thanks for the input Pete
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks