arc90 lab | tools: Link Thumbnail
Excel Help Forum
ExcelTip.com
Account Icon Account Icon Account Icon
ExcelTip.com

Go Back   Excel Help Forum > Microsoft Office Application Help - Excel Help forum > Excel Programming > Excel Charting

Reply
 
Thread Tools Search this Thread Display Modes
  #1  
Old 10-25-2005, 11:05 AM
ignatius
Guest
 
Posts: n/a
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?

Reply With Quote
  #2  
Old 10-25-2005, 01:05 PM
Andy Pope
Guest
 
Posts: n/a
Re: Changing 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
Reply With Quote
Reply

Bookmarks

New topics in Excel Charting


Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are Off
Pingbacks are Off
Refbacks are Off
Forum Jump


All times are GMT -4. The time now is 07:36 PM.


Powered by vBulletin® Version 3.7.4
Copyright ©2000 - 2009, Jelsoft Enterprises Ltd.
Search Engine Friendly URLs by vBSEO 3.2.0