Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Remove white area on chart
Hi
This seems like it should be simple but is not. I have created an Excel 2007 coulmn chart. I then modify the data the chart uses so it is only using 2 columns of data, not 5 and the 2 columns are not next 2 each other. Fine, I've now got the chart showing the data I want, but I'm left with a big space where the 3 columns were previously, on the right of my chart. How do I get rid of the empty columns so my chart fills the plot area fully? Thanks |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
Remove white area on chart
The data for the 2 columns have to be next to each other. Otherwise
Excel will consider the gaps in the data as data points with zero value. Or, hide the rows (columns?) with the missing data - assuming you can hide those rows. The default in 2007 is to not show data from hidden rows. On Thu, 15 Oct 2009 08:18:54 -0700, Lozzaw wrote: Hi This seems like it should be simple but is not. I have created an Excel 2007 coulmn chart. I then modify the data the chart uses so it is only using 2 columns of data, not 5 and the 2 columns are not next 2 each other. Fine, I've now got the chart showing the data I want, but I'm left with a big space where the 3 columns were previously, on the right of my chart. How do I get rid of the empty columns so my chart fills the plot area fully? Thanks Regards, Tushar Mehta Microsoft MVP Excel 2000-present www.tushar-mehta.com Excel and PowerPoint tutorials and add-ins |
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
Remove white area on chart
Try this. Activate the chart. There should be colored rectangles around the
data that is being used. Move the cursor to a handle on the bottom until it changes to a double-headed diagonal arrow. Click and drag upward until the rectangle is around just the data you want plotted. Then release. If you activate the chart, this will move both rectangles together. If you activate the bars, it will move one rectangle at a time. I hope this helps. "Lozzaw" wrote: Hi This seems like it should be simple but is not. I have created an Excel 2007 coulmn chart. I then modify the data the chart uses so it is only using 2 columns of data, not 5 and the 2 columns are not next 2 each other. Fine, I've now got the chart showing the data I want, but I'm left with a big space where the 3 columns were previously, on the right of my chart. How do I get rid of the empty columns so my chart fills the plot area fully? Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Eliminate "white space" at edge of area chart data series | Charts and Charting in Excel | |||
how to remove dotted line with words chart area from around chart | Charts and Charting in Excel | |||
I can't remove the Chart Area dotted lines around my charts. | Charts and Charting in Excel | |||
Legend area white space | Charts and Charting in Excel | |||
How do I remove white space around a chart? | Charts and Charting in Excel |