If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Category displayed as time scale
Hello,
I tried to figure this out for an hour. I have the following data: Y X - - 1 10 2 16 3 20 4 25 5 32 6 40 7 48 8 59 9 71 10 90 I tried using a line chart, but it looks like a straight line. I would like to display it properly like make it look like an exponential chart. I can do this with the time scale, but it changes the labeling on my x-axis. What I would like to do is be able to plot my data as a line chart, but yet have the X-axis display from 0 to 100. Any tips? Thanks! |
#2
|
|||
|
|||
Category displayed as time scale
Hi,
Try using the xy scatter chart (Value x-axis) instead of the Line chart (Category x-axis). It will also make it easier to use the chart wizard if you swapped the layout of your data so the X values are in the first column. Cheers Andy PPP wrote: Hello, I tried to figure this out for an hour. I have the following data: Y X - - 1 10 2 16 3 20 4 25 5 32 6 40 7 48 8 59 9 71 10 90 I tried using a line chart, but it looks like a straight line. I would like to display it properly like make it look like an exponential chart. I can do this with the time scale, but it changes the labeling on my x-axis. What I would like to do is be able to plot my data as a line chart, but yet have the X-axis display from 0 to 100. Any tips? Thanks! -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info |
#3
|
|||
|
|||
Category displayed as time scale
Thanks!
|
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Time Zone suggestions for Outlook Calendar | Ben Knox | Calendar | 2 | October 20th, 2005 03:42 PM |
How do I get the correct time displayed in the Outlook Inbox windo | Diane | General Discussion | 4 | May 9th, 2005 11:54 PM |
Time scale axis should be available in PivotChart Report. | vertblancrouge | Charts and Charting | 1 | April 11th, 2005 01:42 AM |
Use first record found in expression? | CASJAS | Running & Setting Up Queries | 17 | July 22nd, 2004 09:21 PM |
Time scale chart | George Wilson | Charts and Charting | 2 | December 9th, 2003 03:43 PM |