|
Chart Shows data wrong way around
Hi,
I have this strange problem with a simple chart. Y Axis shows correct £0.00 - and scaling upwards. X Axis is the problem. As you look at the chart the X axis displays the days correct 1 2 3 4 5 and so on. Now the problem is the actual bars read right to left, so day 1 has the bar over it for the last day and the last day has the bar for day 1. I am no way an Excel expert :) so if this is something very obvious then "opps" but any help is much appreciated on how to have them matching up correctly. |
Chart Shows data wrong way around
I don't know why yours is backwards. If it is a horizontal bar chart, the
bars start with the first at the bottom (closest to the origin), which is the opposite of their order in the worksheet. Double click the "backwards" axis, check the "Categories in reverse order" box and the "Value axis crosses at maximum category" box. Or if they're both checked, uncheck them. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ wrote in message ... Hi, I have this strange problem with a simple chart. Y Axis shows correct £0.00 - and scaling upwards. X Axis is the problem. As you look at the chart the X axis displays the days correct 1 2 3 4 5 and so on. Now the problem is the actual bars read right to left, so day 1 has the bar over it for the last day and the last day has the bar for day 1. I am no way an Excel expert :) so if this is something very obvious then "opps" but any help is much appreciated on how to have them matching up correctly. |
Chart Shows data wrong way around
On Jan 15, 12:38*pm, "Jon Peltier"
wrote: I don't know why yours is backwards. If it is a horizontal bar chart, the bars start with the first at the bottom (closest to the origin), which is the opposite of their order in the worksheet. Double click the "backwards" axis, check the "Categories in reverse order" box and the "Value axis crosses at maximum category" box. Or if they're both checked, uncheck them. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. -http://PeltierTech.com _______ wrote in message ... Hi, I have this strange problem with a simple chart. Y Axis shows correct £0.00 - and scaling upwards. X Axis is the problem. As you look at the chart the X axis displays the days correct 1 2 3 4 5 *and so on. Now the problem is the actual bars read right to left, so day 1 has the bar over it for the last day and the last day has the bar for day 1. I am no way an Excel expert :) so if this is something very obvious then "opps" but any help is much appreciated on how to have them matching up correctly. I will try and explain a little more Any data added is always inserted at the first row, so as the chart reads the data I guess top to bottom. Which displays as you look at the chart right-left. For me I would look at the chart left to right, left day one right latest day. I guess it is just the way Excel generates charts. But thanks for your reply :) |
Chart Shows data wrong way around
Without seeing what the data looks like, it's hard to know exactly what you
need. Are the values listed in reverse order in the sheet? Then in a simple line or column chart, they will be plotted in the reverse order. The first row will be in the first category position, etc. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ wrote in message ... On Jan 15, 12:38 pm, "Jon Peltier" wrote: I don't know why yours is backwards. If it is a horizontal bar chart, the bars start with the first at the bottom (closest to the origin), which is the opposite of their order in the worksheet. Double click the "backwards" axis, check the "Categories in reverse order" box and the "Value axis crosses at maximum category" box. Or if they're both checked, uncheck them. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. -http://PeltierTech.com _______ wrote in message ... Hi, I have this strange problem with a simple chart. Y Axis shows correct £0.00 - and scaling upwards. X Axis is the problem. As you look at the chart the X axis displays the days correct 1 2 3 4 5 and so on. Now the problem is the actual bars read right to left, so day 1 has the bar over it for the last day and the last day has the bar for day 1. I am no way an Excel expert :) so if this is something very obvious then "opps" but any help is much appreciated on how to have them matching up correctly. I will try and explain a little more Any data added is always inserted at the first row, so as the chart reads the data I guess top to bottom. Which displays as you look at the chart right-left. For me I would look at the chart left to right, left day one right latest day. I guess it is just the way Excel generates charts. But thanks for your reply :) |
Chart Shows data wrong way around
On Jan 15, 4:01*pm, "Jon Peltier"
wrote: Without seeing what the data looks like, it's hard to know exactly what you need. Are the values listed in reverse order in the sheet? Then in a simple line or column chart, they will be plotted in the reverse order. The first row will be in the first category position, etc. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. -http://PeltierTech.com _______ wrote in message ... On Jan 15, 12:38 pm, "Jon Peltier" wrote: I don't know why yours is backwards. If it is a horizontal bar chart, the bars start with the first at the bottom (closest to the origin), which is the opposite of their order in the worksheet. Double click the "backwards" axis, check the "Categories in reverse order" box and the "Value axis crosses at maximum category" box. Or if they're both checked, uncheck them. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. -http://PeltierTech.com _______ wrote in message ... Hi, I have this strange problem with a simple chart. Y Axis shows correct £0.00 - and scaling upwards. X Axis is the problem. As you look at the chart the X axis displays the days correct 1 2 3 4 5 and so on. Now the problem is the actual bars read right to left, so day 1 has the bar over it for the last day and the last day has the bar for day 1. I am no way an Excel expert :) so if this is something very obvious then "opps" but any help is much appreciated on how to have them matching up correctly. I will try and explain a little more Any data added is always inserted at the first row, so as the chart reads the data I guess top to bottom. Which displays as you look at the chart right-left. For me I would look at the chart left to right, left day one right latest day. I guess it is just the way Excel generates charts. But thanks for your reply :)- Hide quoted text - - Show quoted text - Mail I mail you the sheet for you to look at please? - Martin |
Chart Shows data wrong way around
1. Please post on top of the thread like most others do. This makes it
easier to read in sequence. 2. Just post some of the data as text in a reply. I don't have time to read every workbook I'm sent. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ wrote in message ... On Jan 15, 4:01 pm, "Jon Peltier" wrote: Without seeing what the data looks like, it's hard to know exactly what you need. Are the values listed in reverse order in the sheet? Then in a simple line or column chart, they will be plotted in the reverse order. The first row will be in the first category position, etc. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. -http://PeltierTech.com _______ wrote in message ... On Jan 15, 12:38 pm, "Jon Peltier" wrote: I don't know why yours is backwards. If it is a horizontal bar chart, the bars start with the first at the bottom (closest to the origin), which is the opposite of their order in the worksheet. Double click the "backwards" axis, check the "Categories in reverse order" box and the "Value axis crosses at maximum category" box. Or if they're both checked, uncheck them. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. -http://PeltierTech.com _______ wrote in message ... Hi, I have this strange problem with a simple chart. Y Axis shows correct £0.00 - and scaling upwards. X Axis is the problem. As you look at the chart the X axis displays the days correct 1 2 3 4 5 and so on. Now the problem is the actual bars read right to left, so day 1 has the bar over it for the last day and the last day has the bar for day 1. I am no way an Excel expert :) so if this is something very obvious then "opps" but any help is much appreciated on how to have them matching up correctly. I will try and explain a little more Any data added is always inserted at the first row, so as the chart reads the data I guess top to bottom. Which displays as you look at the chart right-left. For me I would look at the chart left to right, left day one right latest day. I guess it is just the way Excel generates charts. But thanks for your reply :)- Hide quoted text - - Show quoted text - Mail I mail you the sheet for you to look at please? - Martin |
| All times are GMT +1. The time now is 08:15 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com