Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
X axis Scale
I have a bar graph with dates for the X axis. I have 3 months, Jul 08, Aug
08 & Sep 09. The X axis displays all the 08 months up to Sep 09. How do I stop the other 08 months from showing up. The bars on the graph are separated, I want them all together. |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
X axis Scale
Hi,
Here are a number of things to do depending on what you mean by separated 1. If there should be only one month per bar - select the chart and choose Chart, Chart Options, Axes, Category 2. Double-click the series on the chart and choose Options, Gap width 0 3. If you are displaying all the dates through Sept 09, it means that the range include those dates. You need to reduce the Source Range. - With the series selected on the chart notice that the range for the labels and data are highlight with blue and purple borders. Place your mouse over the bottom right corner blue square and when the mouse changes to a two headed arrow drag it up or left as is appropriate to decrease the selection size. Repeat this with the purple highlight. -- Thanks, Shane Devenshire "Hezzy" wrote: I have a bar graph with dates for the X axis. I have 3 months, Jul 08, Aug 08 & Sep 09. The X axis displays all the 08 months up to Sep 09. How do I stop the other 08 months from showing up. The bars on the graph are separated, I want them all together. |
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
X axis Scale
Is there a way to upload a file so you can see exactly what I'm talking
about, it's hard to describe in words. "ShaneDevenshire" wrote: Hi, Here are a number of things to do depending on what you mean by separated 1. If there should be only one month per bar - select the chart and choose Chart, Chart Options, Axes, Category 2. Double-click the series on the chart and choose Options, Gap width 0 3. If you are displaying all the dates through Sept 09, it means that the range include those dates. You need to reduce the Source Range. - With the series selected on the chart notice that the range for the labels and data are highlight with blue and purple borders. Place your mouse over the bottom right corner blue square and when the mouse changes to a two headed arrow drag it up or left as is appropriate to decrease the selection size. Repeat this with the purple highlight. -- Thanks, Shane Devenshire "Hezzy" wrote: I have a bar graph with dates for the X axis. I have 3 months, Jul 08, Aug 08 & Sep 09. The X axis displays all the 08 months up to Sep 09. How do I stop the other 08 months from showing up. The bars on the graph are separated, I want them all together. |
#4
Posted to microsoft.public.excel.charting
|
|||
|
|||
X axis Scale
Thank you so much Shane, I clicked on Category in the scale and wallah my
graph was all better. "Hezzy" wrote: Is there a way to upload a file so you can see exactly what I'm talking about, it's hard to describe in words. "ShaneDevenshire" wrote: Hi, Here are a number of things to do depending on what you mean by separated 1. If there should be only one month per bar - select the chart and choose Chart, Chart Options, Axes, Category 2. Double-click the series on the chart and choose Options, Gap width 0 3. If you are displaying all the dates through Sept 09, it means that the range include those dates. You need to reduce the Source Range. - With the series selected on the chart notice that the range for the labels and data are highlight with blue and purple borders. Place your mouse over the bottom right corner blue square and when the mouse changes to a two headed arrow drag it up or left as is appropriate to decrease the selection size. Repeat this with the purple highlight. -- Thanks, Shane Devenshire "Hezzy" wrote: I have a bar graph with dates for the X axis. I have 3 months, Jul 08, Aug 08 & Sep 09. The X axis displays all the 08 months up to Sep 09. How do I stop the other 08 months from showing up. The bars on the graph are separated, I want them all together. |
#5
Posted to microsoft.public.excel.charting
|
|||
|
|||
X axis Scale
Now I have the same problem with a line graph. There is no category under
scale to check. How to I fix a line graph? "Hezzy" wrote: Thank you so much Shane, I clicked on Category in the scale and wallah my graph was all better. "Hezzy" wrote: Is there a way to upload a file so you can see exactly what I'm talking about, it's hard to describe in words. "ShaneDevenshire" wrote: Hi, Here are a number of things to do depending on what you mean by separated 1. If there should be only one month per bar - select the chart and choose Chart, Chart Options, Axes, Category 2. Double-click the series on the chart and choose Options, Gap width 0 3. If you are displaying all the dates through Sept 09, it means that the range include those dates. You need to reduce the Source Range. - With the series selected on the chart notice that the range for the labels and data are highlight with blue and purple borders. Place your mouse over the bottom right corner blue square and when the mouse changes to a two headed arrow drag it up or left as is appropriate to decrease the selection size. Repeat this with the purple highlight. -- Thanks, Shane Devenshire "Hezzy" wrote: I have a bar graph with dates for the X axis. I have 3 months, Jul 08, Aug 08 & Sep 09. The X axis displays all the 08 months up to Sep 09. How do I stop the other 08 months from showing up. The bars on the graph are separated, I want them all together. |
#6
Posted to microsoft.public.excel.charting
|
|||
|
|||
X axis Scale
Hi,
Sorry to take so long getting back, yes Just send it to me -- Thanks, Shane Devenshire "Hezzy" wrote: I have a bar graph with dates for the X axis. I have 3 months, Jul 08, Aug 08 & Sep 09. The X axis displays all the 08 months up to Sep 09. How do I stop the other 08 months from showing up. The bars on the graph are separated, I want them all together. |
#7
Posted to microsoft.public.excel.charting
|
|||
|
|||
X axis Scale
Hi,
Same options available for line charts. -- Thanks, Shane Devenshire "Hezzy" wrote: Now I have the same problem with a line graph. There is no category under scale to check. How to I fix a line graph? "Hezzy" wrote: Thank you so much Shane, I clicked on Category in the scale and wallah my graph was all better. "Hezzy" wrote: Is there a way to upload a file so you can see exactly what I'm talking about, it's hard to describe in words. "ShaneDevenshire" wrote: Hi, Here are a number of things to do depending on what you mean by separated 1. If there should be only one month per bar - select the chart and choose Chart, Chart Options, Axes, Category 2. Double-click the series on the chart and choose Options, Gap width 0 3. If you are displaying all the dates through Sept 09, it means that the range include those dates. You need to reduce the Source Range. - With the series selected on the chart notice that the range for the labels and data are highlight with blue and purple borders. Place your mouse over the bottom right corner blue square and when the mouse changes to a two headed arrow drag it up or left as is appropriate to decrease the selection size. Repeat this with the purple highlight. -- Thanks, Shane Devenshire "Hezzy" wrote: I have a bar graph with dates for the X axis. I have 3 months, Jul 08, Aug 08 & Sep 09. The X axis displays all the 08 months up to Sep 09. How do I stop the other 08 months from showing up. The bars on the graph are separated, I want them all together. |
#8
Posted to microsoft.public.excel.charting
|
|||
|
|||
X axis Scale
I'm using Excel 2000 and the category option is not available.
"ShaneDevenshire" wrote: Hi, Same options available for line charts. -- Thanks, Shane Devenshire "Hezzy" wrote: Now I have the same problem with a line graph. There is no category under scale to check. How to I fix a line graph? "Hezzy" wrote: Thank you so much Shane, I clicked on Category in the scale and wallah my graph was all better. "Hezzy" wrote: Is there a way to upload a file so you can see exactly what I'm talking about, it's hard to describe in words. "ShaneDevenshire" wrote: Hi, Here are a number of things to do depending on what you mean by separated 1. If there should be only one month per bar - select the chart and choose Chart, Chart Options, Axes, Category 2. Double-click the series on the chart and choose Options, Gap width 0 3. If you are displaying all the dates through Sept 09, it means that the range include those dates. You need to reduce the Source Range. - With the series selected on the chart notice that the range for the labels and data are highlight with blue and purple borders. Place your mouse over the bottom right corner blue square and when the mouse changes to a two headed arrow drag it up or left as is appropriate to decrease the selection size. Repeat this with the purple highlight. -- Thanks, Shane Devenshire "Hezzy" wrote: I have a bar graph with dates for the X axis. I have 3 months, Jul 08, Aug 08 & Sep 09. The X axis displays all the 08 months up to Sep 09. How do I stop the other 08 months from showing up. The bars on the graph are separated, I want them all together. |
#9
Posted to microsoft.public.excel.charting
|
|||
|
|||
X axis Scale
Hi,
The same 3 options are available for line charts in xl2000. In fact xl97 also has them. Chart Options Axis Primary Axis Category Cheers Andy Hezzy wrote: I'm using Excel 2000 and the category option is not available. "ShaneDevenshire" wrote: Hi, Same options available for line charts. -- Thanks, Shane Devenshire "Hezzy" wrote: Now I have the same problem with a line graph. There is no category under scale to check. How to I fix a line graph? "Hezzy" wrote: Thank you so much Shane, I clicked on Category in the scale and wallah my graph was all better. "Hezzy" wrote: Is there a way to upload a file so you can see exactly what I'm talking about, it's hard to describe in words. "ShaneDevenshire" wrote: Hi, Here are a number of things to do depending on what you mean by separated 1. If there should be only one month per bar - select the chart and choose Chart, Chart Options, Axes, Category 2. Double-click the series on the chart and choose Options, Gap width 0 3. If you are displaying all the dates through Sept 09, it means that the range include those dates. You need to reduce the Source Range. - With the series selected on the chart notice that the range for the labels and data are highlight with blue and purple borders. Place your mouse over the bottom right corner blue square and when the mouse changes to a two headed arrow drag it up or left as is appropriate to decrease the selection size. Repeat this with the purple highlight. -- Thanks, Shane Devenshire "Hezzy" wrote: I have a bar graph with dates for the X axis. I have 3 months, Jul 08, Aug 08 & Sep 09. The X axis displays all the 08 months up to Sep 09. How do I stop the other 08 months from showing up. The bars on the graph are separated, I want them all together. -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to draw chart: log scale on X axis, natural scale on y axis? | Charts and Charting in Excel | |||
How do I reference x-axis or y-axis scale values to a worksheet ce | Excel Discussion (Misc queries) | |||
How to make Primary axis and Secondary X-axis have the same scale | Excel Discussion (Misc queries) | |||
Format Axis; Scale Tab; "Value Axis Crosses At" ends with preposit | Charts and Charting in Excel | |||
How to insert X axis scale values next to axis and X axis grid lin | Charts and Charting in Excel |