| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Plot areas
I am using a column and area chart. The area portion behind the columns looks
untidy because it extends from the middle of the first column to the middle of the last column. How do I change the area display to so that it starts at the left edge of the first column and goes to the right edge of the last column? |
|
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
Plot areas
Hi,
Double click the X axis and on the scale tab uncheck 'Value (Y) axis crosses between categories'. This will make the area chart extend to the edge of the plot area. But it may also do the same to the columns. Cheers Andy Lynda wrote: I am using a column and area chart. The area portion behind the columns looks untidy because it extends from the middle of the first column to the middle of the last column. How do I change the area display to so that it starts at the left edge of the first column and goes to the right edge of the last column? -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info |
|
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
Plot areas
Thank you Andy. You were right it does extend the columns as well. As long as
the information is right they will just have to accept the way it looks . "Andy Pope" wrote: Hi, Double click the X axis and on the scale tab uncheck 'Value (Y) axis crosses between categories'. This will make the area chart extend to the edge of the plot area. But it may also do the same to the columns. Cheers Andy Lynda wrote: I am using a column and area chart. The area portion behind the columns looks untidy because it extends from the middle of the first column to the middle of the last column. How do I change the area display to so that it starts at the left edge of the first column and goes to the right edge of the last column? -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info |
|
#4
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
Plot areas
Hi,
You can move one of the series to the secondary. But then the area points will not align with the columns center. Cheers Andy Lynda wrote: Thank you Andy. You were right it does extend the columns as well. As long as the information is right they will just have to accept the way it looks . "Andy Pope" wrote: Hi, Double click the X axis and on the scale tab uncheck 'Value (Y) axis crosses between categories'. This will make the area chart extend to the edge of the plot area. But it may also do the same to the columns. Cheers Andy Lynda wrote: I am using a column and area chart. The area portion behind the columns looks untidy because it extends from the middle of the first column to the middle of the last column. How do I change the area display to so that it starts at the left edge of the first column and goes to the right edge of the last column? -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How To: Easy Box Plot | Charts and Charting in Excel | |||
| fixed plot areas? | Charts and Charting in Excel | |||
| Aligning two chart plot areas - simple but tricky! | Charts and Charting in Excel | |||
| Multiple plot areas | Charts and Charting in Excel | |||
| Plot Wizard -- "Not enough system resources to display completely. | Charts and Charting in Excel | |||
Linear Mode
