ExcelBanter - Changing axis

ExcelBanter (https://www.excelbanter.com/)

- Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)

- - Changing axis (https://www.excelbanter.com/charts-charting-excel/52190-changing-axis.html)

I have created a chart that plots visitors to a site over a period of
time. Now the chart has the dates on X axis and the data is plotted
along Y axis (0 to 5000).

How do I lay the chart so that the date is on the Y axis and the 0 to
5000 is on the X axis?

Hi,

If the chart is a line chart try changing it to a xy scatter instead.
You may need to adjust the data series values to get the correct x an y
values.

Cheers
Andy

ignatius wrote:
I have created a chart that plots visitors to a site over a period of
time. Now the chart has the dates on X axis and the data is plotted
along Y axis (0 to 5000).

How do I lay the chart so that the date is on the Y axis and the 0 to
5000 is on the X axis?

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info