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
|
|||
|
|||
X axis problem
HI
I have an existing chart that has days for the X axis and numbers for the Y but to indicate the weeks we use 2 columns in the raw data and then link them in the Category (x) axis labels='28'!$A$2:$B$23 This worked until I tried to add vertical lines using the Scatter Plot method. With the Axis set to ='28'!$B$2:$B$23 the graph is ok and shows the days and the vertical marker on the correct day but is missing the markers for the weeks but if I set the axis to A and B column all the data is off the left side of the chart and unusable. So how do I do both have the scatter plot for vertical markers and multi level x axis? Here is an example of the data. W02 9-Jan 99.39% 10-Jan 99.18% 11-Jan 99.35% 12-Jan 99.34% 13-Jan 99.32% 14-Jan 99.37% 15-Jan 99.43% W03 16-Jan 99.39% 17-Jan 99.30% 18-Jan 99.25% 19-Jan 99.22% 20-Jan 99.39% 21-Jan 99.34% 22-Jan 99.33% W04 23-Jan 99.39% 24-Jan 99.36% 25-Jan 99.39% Mark |
#2
|
|||
|
|||
X axis problem
Mark -
For the X values of the scatter series, you can't use dates, because Excel doesn't recognize multiple level category axis values as numerical. Count the number of categories, starting with 1 for W02 9-Jan. Depending on whether you want the lines to be positioned on or between the existing chart's points, use these category numbers, or add/subtract 0.5. - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services Tutorials and Custom Solutions http://PeltierTech.com/ _______ "Mark" wrote in message ... HI I have an existing chart that has days for the X axis and numbers for the Y but to indicate the weeks we use 2 columns in the raw data and then link them in the Category (x) axis labels='28'!$A$2:$B$23 This worked until I tried to add vertical lines using the Scatter Plot method. With the Axis set to ='28'!$B$2:$B$23 the graph is ok and shows the days and the vertical marker on the correct day but is missing the markers for the weeks but if I set the axis to A and B column all the data is off the left side of the chart and unusable. So how do I do both have the scatter plot for vertical markers and multi level x axis? Here is an example of the data. W02 9-Jan 99.39% 10-Jan 99.18% 11-Jan 99.35% 12-Jan 99.34% 13-Jan 99.32% 14-Jan 99.37% 15-Jan 99.43% W03 16-Jan 99.39% 17-Jan 99.30% 18-Jan 99.25% 19-Jan 99.22% 20-Jan 99.39% 21-Jan 99.34% 22-Jan 99.33% W04 23-Jan 99.39% 24-Jan 99.36% 25-Jan 99.39% Mark |
#3
|
|||
|
|||
X axis problem
Thanks
That did the job. Mark "Jon Peltier" wrote in message ... Mark - For the X values of the scatter series, you can't use dates, because Excel doesn't recognize multiple level category axis values as numerical. Count the number of categories, starting with 1 for W02 9-Jan. Depending on whether you want the lines to be positioned on or between the existing chart's points, use these category numbers, or add/subtract 0.5. - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services Tutorials and Custom Solutions http://PeltierTech.com/ _______ "Mark" wrote in message ... HI I have an existing chart that has days for the X axis and numbers for the Y but to indicate the weeks we use 2 columns in the raw data and then link them in the Category (x) axis labels='28'!$A$2:$B$23 This worked until I tried to add vertical lines using the Scatter Plot method. With the Axis set to ='28'!$B$2:$B$23 the graph is ok and shows the days and the vertical marker on the correct day but is missing the markers for the weeks but if I set the axis to A and B column all the data is off the left side of the chart and unusable. So how do I do both have the scatter plot for vertical markers and multi level x axis? Here is an example of the data. W02 9-Jan 99.39% 10-Jan 99.18% 11-Jan 99.35% 12-Jan 99.34% 13-Jan 99.32% 14-Jan 99.37% 15-Jan 99.43% W03 16-Jan 99.39% 17-Jan 99.30% 18-Jan 99.25% 19-Jan 99.22% 20-Jan 99.39% 21-Jan 99.34% 22-Jan 99.33% W04 23-Jan 99.39% 24-Jan 99.36% 25-Jan 99.39% Mark |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
can't change how data on 2nd axis is being displayed | Rebekah | Charts and Charting | 1 | May 4th, 2005 02:51 PM |
How do I get around the problem where x and y axis labels in Micr. | Dixit Dominus | Charts and Charting | 1 | April 22nd, 2005 08:11 PM |
Value Axis Scale Change Problem | dp_fulcher | Charts and Charting | 1 | October 19th, 2004 01:21 PM |
Problem with the display of a 2 axis chart | Peter B | Charts and Charting | 1 | August 4th, 2004 02:39 AM |
force graph to axis of choice | Tushar Mehta | Charts and Charting | 3 | February 11th, 2004 04:04 PM |