Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
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
Posted to microsoft.public.excel.charting
|
|||
|
|||
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
Posted to microsoft.public.excel.charting
|
|||
|
|||
Category displayed as time scale
Thanks!
|
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Hot key for time? | New Users to Excel | |||
Hot key for time? | Excel Worksheet Functions | |||
Hot key for time? | Excel Discussion (Misc queries) | |||
time sheet to calculate 2 different columns | Excel Worksheet Functions | |||
time scale axis | Charts and Charting in Excel |