Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Auto Year scale
Hi everyone,
I have some data that I am trying to plot by year, without having to put in the year. When I do the auto year set-up it seems like it binds the dataset to the year 2000. When I try to change the scale I can no longer see the data. What gives? I'm trying to plot taper of a part over the years, but I want multiple parts on the same chart. |
#2
|
|||
|
|||
Do you just have years, or full dates (like 1-Jan-2000)? Is it a line chart or a
scatter chart? What do you mean, "without having to put in the years"? - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services Tutorials and Custom Solutions http://PeltierTech.com/ _______ John Sawyer wrote: Hi everyone, I have some data that I am trying to plot by year, without having to put in the year. When I do the auto year set-up it seems like it binds the dataset to the year 2000. When I try to change the scale I can no longer see the data. What gives? I'm trying to plot taper of a part over the years, but I want multiple parts on the same chart. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How can I turn auto correct on or off for one column only? | Excel Worksheet Functions | |||
Chart Axis Scale Auto Values | Charts and Charting in Excel | |||
Excel Charts - Data being Plotted beyond Primary X-Axis Scale | Charts and Charting in Excel | |||
excel links update not working in auto, calculations in auto | Excel Worksheet Functions | |||
Why can't my macro use Auto Filter when I told the Sheet Protecti. | Excel Worksheet Functions |