When making a chart, is there a way to change the x values? I want them to be listed as dates instead of just 1, 2, 3...
momtworugrats 0 Newbie Poster
timothybard 12 Posting Whiz
Yes, you can have the x values as dates.
1) List your dates in a column.
2) List your y values in the column to the right of your dates
3) Highlight the Dates and y values and click on the Chart wizard icon.
4) On step 3 of 4 of the chart wizard, click on the Axes tab.
5) For the Category (X) axis, select Time-Scale.
This will make Excel treat the dates as vales and not categories.
You can read more about this here:
http://peltiertech.com/Excel/ChartsHowTo/CatVsValueAxis.html
Be a part of the DaniWeb community
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.