Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
xl 2007 bug?
Hello,
Does anyone know if this is a "known feature" of Excel 2007: I have selected a data arera of, say, 18 columns. My chart obediently displays all the data. When I separate the data into 2 series and add a 2nd value axis the following happens: The chart drops the last two data points of the data! Am I -missing a new setting, -fighting in vain against a bug or -missing something? Grateful for any tip, Kristian |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
xl 2007 bug?
What type of chart?
You have 18 columns, how many rows, where are your X values or labels, are you plotting by row or column? How are you splitting this into two series? - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "kkarre" wrote in message ... Hello, Does anyone know if this is a "known feature" of Excel 2007: I have selected a data arera of, say, 18 columns. My chart obediently displays all the data. When I separate the data into 2 series and add a 2nd value axis the following happens: The chart drops the last two data points of the data! Am I -missing a new setting, -fighting in vain against a bug or -missing something? Grateful for any tip, Kristian |
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
xl 2007 bug?
Line chart
18 data points 2 of them moved to a new row=new series 3 rows (2 series + 1 category axis) /Kristian "Jon Peltier" wrote: What type of chart? You have 18 columns, how many rows, where are your X values or labels, are you plotting by row or column? How are you splitting this into two series? - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "kkarre" wrote in message ... Hello, Does anyone know if this is a "known feature" of Excel 2007: I have selected a data arera of, say, 18 columns. My chart obediently displays all the data. When I separate the data into 2 series and add a 2nd value axis the following happens: The chart drops the last two data points of the data! Am I -missing a new setting, -fighting in vain against a bug or -missing something? Grateful for any tip, Kristian |
#4
Posted to microsoft.public.excel.charting
|
|||
|
|||
xl 2007 bug?
Hi,
Based on your response to Jon's question I'm not sure what you mean when you say "when I separate the data into two series"? from you response to Jon/s question it sounds line you have three rows of data feeding your chart, one with category info and two for series. So when you say separate the data what exactly do you mean? I created a line chart in 2007 with titles in A1:S1 and one series in A2:S2 and the second in A3:S3. After plotting it, I selected one of the series and choose Format, Format Selection, and under Series Options chose Secondary Axis. Everything is just fine. Based on your description I can't duplicate the problem. -- Thanks, Shane Devenshire "kkarre" wrote: Hello, Does anyone know if this is a "known feature" of Excel 2007: I have selected a data arera of, say, 18 columns. My chart obediently displays all the data. When I separate the data into 2 series and add a 2nd value axis the following happens: The chart drops the last two data points of the data! Am I -missing a new setting, -fighting in vain against a bug or -missing something? Grateful for any tip, Kristian |
#5
Posted to microsoft.public.excel.charting
|
|||
|
|||
xl 2007 bug?
Here's what I did. I put 18 labels in A1:R1 and 18 values in A2:R2. I made a
line chart, no problem. I dragged cells Q2:R2 down a row to Q3:R3. Naturally they fell off of the chart (though the chart still had 18 points). I used A3:R3 as the Y values for a second series, and the last two points showed up right where they had been at the end of the other series. Changing this series to the secondary axis did not affect whether the points appeared or not. What did you do differently? - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "kkarre" wrote in message ... Line chart 18 data points 2 of them moved to a new row=new series 3 rows (2 series + 1 category axis) /Kristian "Jon Peltier" wrote: What type of chart? You have 18 columns, how many rows, where are your X values or labels, are you plotting by row or column? How are you splitting this into two series? - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "kkarre" wrote in message ... Hello, Does anyone know if this is a "known feature" of Excel 2007: I have selected a data arera of, say, 18 columns. My chart obediently displays all the data. When I separate the data into 2 series and add a 2nd value axis the following happens: The chart drops the last two data points of the data! Am I -missing a new setting, -fighting in vain against a bug or -missing something? Grateful for any tip, Kristian |
#6
Posted to microsoft.public.excel.charting
|
|||
|
|||
xl 2007 bug?
My own error;
The selection for categories was wrong and therefore the last two data points didn't show... Thanks 4 your help! /kk "ShaneDevenshire" wrote: Hi, Based on your response to Jon's question I'm not sure what you mean when you say "when I separate the data into two series"? from you response to Jon/s question it sounds line you have three rows of data feeding your chart, one with category info and two for series. So when you say separate the data what exactly do you mean? I created a line chart in 2007 with titles in A1:S1 and one series in A2:S2 and the second in A3:S3. After plotting it, I selected one of the series and choose Format, Format Selection, and under Series Options chose Secondary Axis. Everything is just fine. Based on your description I can't duplicate the problem. -- Thanks, Shane Devenshire "kkarre" wrote: Hello, Does anyone know if this is a "known feature" of Excel 2007: I have selected a data arera of, say, 18 columns. My chart obediently displays all the data. When I separate the data into 2 series and add a 2nd value axis the following happens: The chart drops the last two data points of the data! Am I -missing a new setting, -fighting in vain against a bug or -missing something? Grateful for any tip, Kristian |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Pasting a chart from Excel 2007 to Word 2007 trouble | Charts and Charting in Excel | |||
changing August 31, 2007 into 31.08.2007 | Excel Worksheet Functions | |||
Exporting Quickbooks 2007 to Excel 2007 | Excel Worksheet Functions | |||
Problems with my links to an excel 2007 file from a word 2007 file | Links and Linking in Excel | |||
Office 2007 Pro Plus 2007 (Beta) - getting small red and green arr | Excel Discussion (Misc queries) |