Thread: Changing axis

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