Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Help with adding x-axis major gridlines
I'm trying to make a chart that will have small tick-marks along the x-axis
for a fiscal week, and a long tick-mark separating the fiscal month. I think I'm not formatting the data properly in the worksheet. Any ideas? |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
Help with adding x-axis major gridlines
Use a Line chart with dates as the X values. Double click the X axis. On the
Scale tab, set the X axis minimum to occur on the 1st of a month. Set the Base Unit to Day(s), the Major Unit to 1 Month(s), the Minor Unit to 7 Day(s). On the Patterns tab, choose whatever for Major Ticks and something besides None for Minor Ticks. Click OK. On the Chart menu, choose Chart Options, and on the Gridlines tab, check the box for Category (X) Axis Major Gridlines. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions http://PeltierTech.com _______ "Judi" wrote in message ... I'm trying to make a chart that will have small tick-marks along the x-axis for a fiscal week, and a long tick-mark separating the fiscal month. I think I'm not formatting the data properly in the worksheet. Any ideas? |
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
Help with adding x-axis major gridlines
This has been very helpful, Jon. Thank you so much. However, each time I
change the setting, it defaults back to its original setting. Is it how I'm formatting the data source? I have the data in there with dates (which I don't want to show up), and I have a fiscal month next to that (which I DO want to show up - and just have the date information as tick marks on the x-axis). Does that make sense? "Jon Peltier" wrote: Use a Line chart with dates as the X values. Double click the X axis. On the Scale tab, set the X axis minimum to occur on the 1st of a month. Set the Base Unit to Day(s), the Major Unit to 1 Month(s), the Minor Unit to 7 Day(s). On the Patterns tab, choose whatever for Major Ticks and something besides None for Minor Ticks. Click OK. On the Chart menu, choose Chart Options, and on the Gridlines tab, check the box for Category (X) Axis Major Gridlines. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions http://PeltierTech.com _______ "Judi" wrote in message ... I'm trying to make a chart that will have small tick-marks along the x-axis for a fiscal week, and a long tick-mark separating the fiscal month. I think I'm not formatting the data properly in the worksheet. Any ideas? |
#4
Posted to microsoft.public.excel.charting
|
|||
|
|||
Help with adding x-axis major gridlines
Judi -
This has been very helpful, Jon. Thank you so much. However, each time I change the setting, it defaults back to its original setting. Is it how I'm formatting the data source? Is it a pivot chart? Pivot charts revert to default formatting at the drop of a hat. Otherwise, I'm not sure I understand your description. I have the data in there with dates (which I don't want to show up), and I have a fiscal month next to that (which I DO want to show up - and just have the date information as tick marks on the x-axis). Does that make sense? If the major unit is 1 month, you can have a label each month, the first if the chart begins on the first of a month. You can format it to show just the name of the month (number format "mmm" for Jan or "mmmm" for January). You can't just move it to the middle of the month, though. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions http://PeltierTech.com _______ "Jon Peltier" wrote: Use a Line chart with dates as the X values. Double click the X axis. On the Scale tab, set the X axis minimum to occur on the 1st of a month. Set the Base Unit to Day(s), the Major Unit to 1 Month(s), the Minor Unit to 7 Day(s). On the Patterns tab, choose whatever for Major Ticks and something besides None for Minor Ticks. Click OK. On the Chart menu, choose Chart Options, and on the Gridlines tab, check the box for Category (X) Axis Major Gridlines. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions http://PeltierTech.com _______ "Judi" wrote in message ... I'm trying to make a chart that will have small tick-marks along the x-axis for a fiscal week, and a long tick-mark separating the fiscal month. I think I'm not formatting the data properly in the worksheet. Any ideas? |
#5
Posted to microsoft.public.excel.charting
|
|||
|
|||
Help with adding x-axis major gridlines
I don't think it's a pivot chart. Let me try to explain again. I'm looking
at some data that's collected each week. I have 52 data points that my boss wants to see - they're hours worked per week. Now, he wants to see bars for that (or whatever we use), but the labels at the bottom - he just wants to see the FISCAL month. For last fiscal year, October was 5 weeks, November 4, December 4, January 5, February 4, etc., with my first data point being Friday, September 30, 2005. So, the x-axis is the week (but he'd like to see labels of months, instead - but FISCAL months, not normal months), and the y-axis is the number of hours. Does that make it any more clear? "Jon Peltier" wrote: Judi - This has been very helpful, Jon. Thank you so much. However, each time I change the setting, it defaults back to its original setting. Is it how I'm formatting the data source? Is it a pivot chart? Pivot charts revert to default formatting at the drop of a hat. Otherwise, I'm not sure I understand your description. I have the data in there with dates (which I don't want to show up), and I have a fiscal month next to that (which I DO want to show up - and just have the date information as tick marks on the x-axis). Does that make sense? If the major unit is 1 month, you can have a label each month, the first if the chart begins on the first of a month. You can format it to show just the name of the month (number format "mmm" for Jan or "mmmm" for January). You can't just move it to the middle of the month, though. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions http://PeltierTech.com _______ "Jon Peltier" wrote: Use a Line chart with dates as the X values. Double click the X axis. On the Scale tab, set the X axis minimum to occur on the 1st of a month. Set the Base Unit to Day(s), the Major Unit to 1 Month(s), the Minor Unit to 7 Day(s). On the Patterns tab, choose whatever for Major Ticks and something besides None for Minor Ticks. Click OK. On the Chart menu, choose Chart Options, and on the Gridlines tab, check the box for Category (X) Axis Major Gridlines. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions http://PeltierTech.com _______ "Judi" wrote in message ... I'm trying to make a chart that will have small tick-marks along the x-axis for a fiscal week, and a long tick-mark separating the fiscal month. I think I'm not formatting the data properly in the worksheet. Any ideas? |
#6
Posted to microsoft.public.excel.charting
|
|||
|
|||
Help with adding x-axis major gridlines
What you can do, which is a bit of a kludge, is arrange your data like this
(view with non-proportional font): Value Jan 1 4 8 5 15 6 22 7 29 8 Feb 5 9 12 10 19 11 26 12 Mar 5 13 12 14 19 15 26 16 The first column is the month if it's the first week of the month, otherwise blank*. The second column is the day of the month. The third column is the data. The first two cells in the top row are blank*, the cell above the values has a label. Make a line or column chart. *These must be true blank cells, not a formula that returns "" to look like a blank. The X axis will look like this, with the month names centered beneath the dates within that month: 1 8 15 22 29 5 12 19 26 5 12 19 26 Jan Feb Mar - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions http://PeltierTech.com _______ "Judi" wrote in message ... I don't think it's a pivot chart. Let me try to explain again. I'm looking at some data that's collected each week. I have 52 data points that my boss wants to see - they're hours worked per week. Now, he wants to see bars for that (or whatever we use), but the labels at the bottom - he just wants to see the FISCAL month. For last fiscal year, October was 5 weeks, November 4, December 4, January 5, February 4, etc., with my first data point being Friday, September 30, 2005. So, the x-axis is the week (but he'd like to see labels of months, instead - but FISCAL months, not normal months), and the y-axis is the number of hours. Does that make it any more clear? "Jon Peltier" wrote: Judi - This has been very helpful, Jon. Thank you so much. However, each time I change the setting, it defaults back to its original setting. Is it how I'm formatting the data source? Is it a pivot chart? Pivot charts revert to default formatting at the drop of a hat. Otherwise, I'm not sure I understand your description. I have the data in there with dates (which I don't want to show up), and I have a fiscal month next to that (which I DO want to show up - and just have the date information as tick marks on the x-axis). Does that make sense? If the major unit is 1 month, you can have a label each month, the first if the chart begins on the first of a month. You can format it to show just the name of the month (number format "mmm" for Jan or "mmmm" for January). You can't just move it to the middle of the month, though. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions http://PeltierTech.com _______ "Jon Peltier" wrote: Use a Line chart with dates as the X values. Double click the X axis. On the Scale tab, set the X axis minimum to occur on the 1st of a month. Set the Base Unit to Day(s), the Major Unit to 1 Month(s), the Minor Unit to 7 Day(s). On the Patterns tab, choose whatever for Major Ticks and something besides None for Minor Ticks. Click OK. On the Chart menu, choose Chart Options, and on the Gridlines tab, check the box for Category (X) Axis Major Gridlines. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions http://PeltierTech.com _______ "Judi" wrote in message ... I'm trying to make a chart that will have small tick-marks along the x-axis for a fiscal week, and a long tick-mark separating the fiscal month. I think I'm not formatting the data properly in the worksheet. Any ideas? |
#7
Posted to microsoft.public.excel.charting
|
|||
|
|||
Help with adding x-axis major gridlines
YES!!!!!!!!!!!!!!!!!!!!!!!!
My boss is thrilled!!! Thank you, Jon!!!! Depending on what he throws at me next, I'll be talking to you again! (And as I live and breathe, he wants a fixed number on the y-axis. I'm going to go look for how to do that, but if you can tell me where...I'll be even happier!) ~Judi "Jon Peltier" wrote: What you can do, which is a bit of a kludge, is arrange your data like this (view with non-proportional font): Value Jan 1 4 8 5 15 6 22 7 29 8 Feb 5 9 12 10 19 11 26 12 Mar 5 13 12 14 19 15 26 16 The first column is the month if it's the first week of the month, otherwise blank*. The second column is the day of the month. The third column is the data. The first two cells in the top row are blank*, the cell above the values has a label. Make a line or column chart. *These must be true blank cells, not a formula that returns "" to look like a blank. The X axis will look like this, with the month names centered beneath the dates within that month: 1 8 15 22 29 5 12 19 26 5 12 19 26 Jan Feb Mar - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions http://PeltierTech.com _______ "Judi" wrote in message ... I don't think it's a pivot chart. Let me try to explain again. I'm looking at some data that's collected each week. I have 52 data points that my boss wants to see - they're hours worked per week. Now, he wants to see bars for that (or whatever we use), but the labels at the bottom - he just wants to see the FISCAL month. For last fiscal year, October was 5 weeks, November 4, December 4, January 5, February 4, etc., with my first data point being Friday, September 30, 2005. So, the x-axis is the week (but he'd like to see labels of months, instead - but FISCAL months, not normal months), and the y-axis is the number of hours. Does that make it any more clear? "Jon Peltier" wrote: Judi - This has been very helpful, Jon. Thank you so much. However, each time I change the setting, it defaults back to its original setting. Is it how I'm formatting the data source? Is it a pivot chart? Pivot charts revert to default formatting at the drop of a hat. Otherwise, I'm not sure I understand your description. I have the data in there with dates (which I don't want to show up), and I have a fiscal month next to that (which I DO want to show up - and just have the date information as tick marks on the x-axis). Does that make sense? If the major unit is 1 month, you can have a label each month, the first if the chart begins on the first of a month. You can format it to show just the name of the month (number format "mmm" for Jan or "mmmm" for January). You can't just move it to the middle of the month, though. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions http://PeltierTech.com _______ "Jon Peltier" wrote: Use a Line chart with dates as the X values. Double click the X axis. On the Scale tab, set the X axis minimum to occur on the 1st of a month. Set the Base Unit to Day(s), the Major Unit to 1 Month(s), the Minor Unit to 7 Day(s). On the Patterns tab, choose whatever for Major Ticks and something besides None for Minor Ticks. Click OK. On the Chart menu, choose Chart Options, and on the Gridlines tab, check the box for Category (X) Axis Major Gridlines. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions http://PeltierTech.com _______ "Judi" wrote in message ... I'm trying to make a chart that will have small tick-marks along the x-axis for a fiscal week, and a long tick-mark separating the fiscal month. I think I'm not formatting the data properly in the worksheet. Any ideas? |
#8
Posted to microsoft.public.excel.charting
|
|||
|
|||
Help with adding x-axis major gridlines
FOUND IT! Thanks again!!!
"Judi" wrote: YES!!!!!!!!!!!!!!!!!!!!!!!! My boss is thrilled!!! Thank you, Jon!!!! Depending on what he throws at me next, I'll be talking to you again! (And as I live and breathe, he wants a fixed number on the y-axis. I'm going to go look for how to do that, but if you can tell me where...I'll be even happier!) ~Judi "Jon Peltier" wrote: What you can do, which is a bit of a kludge, is arrange your data like this (view with non-proportional font): Value Jan 1 4 8 5 15 6 22 7 29 8 Feb 5 9 12 10 19 11 26 12 Mar 5 13 12 14 19 15 26 16 The first column is the month if it's the first week of the month, otherwise blank*. The second column is the day of the month. The third column is the data. The first two cells in the top row are blank*, the cell above the values has a label. Make a line or column chart. *These must be true blank cells, not a formula that returns "" to look like a blank. The X axis will look like this, with the month names centered beneath the dates within that month: 1 8 15 22 29 5 12 19 26 5 12 19 26 Jan Feb Mar - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions http://PeltierTech.com _______ "Judi" wrote in message ... I don't think it's a pivot chart. Let me try to explain again. I'm looking at some data that's collected each week. I have 52 data points that my boss wants to see - they're hours worked per week. Now, he wants to see bars for that (or whatever we use), but the labels at the bottom - he just wants to see the FISCAL month. For last fiscal year, October was 5 weeks, November 4, December 4, January 5, February 4, etc., with my first data point being Friday, September 30, 2005. So, the x-axis is the week (but he'd like to see labels of months, instead - but FISCAL months, not normal months), and the y-axis is the number of hours. Does that make it any more clear? "Jon Peltier" wrote: Judi - This has been very helpful, Jon. Thank you so much. However, each time I change the setting, it defaults back to its original setting. Is it how I'm formatting the data source? Is it a pivot chart? Pivot charts revert to default formatting at the drop of a hat. Otherwise, I'm not sure I understand your description. I have the data in there with dates (which I don't want to show up), and I have a fiscal month next to that (which I DO want to show up - and just have the date information as tick marks on the x-axis). Does that make sense? If the major unit is 1 month, you can have a label each month, the first if the chart begins on the first of a month. You can format it to show just the name of the month (number format "mmm" for Jan or "mmmm" for January). You can't just move it to the middle of the month, though. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions http://PeltierTech.com _______ "Jon Peltier" wrote: Use a Line chart with dates as the X values. Double click the X axis. On the Scale tab, set the X axis minimum to occur on the 1st of a month. Set the Base Unit to Day(s), the Major Unit to 1 Month(s), the Minor Unit to 7 Day(s). On the Patterns tab, choose whatever for Major Ticks and something besides None for Minor Ticks. Click OK. On the Chart menu, choose Chart Options, and on the Gridlines tab, check the box for Category (X) Axis Major Gridlines. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions http://PeltierTech.com _______ "Judi" wrote in message ... I'm trying to make a chart that will have small tick-marks along the x-axis for a fiscal week, and a long tick-mark separating the fiscal month. I think I'm not formatting the data properly in the worksheet. Any ideas? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Adding Multiple Lines On A Secondary Axis? | Charts and Charting in Excel | |||
shift Y axis | Charts and Charting in Excel | |||
how to add a second x axis with same Y axis value in one plot | Charts and Charting in Excel | |||
Secondary Axis Match Primary Axis Gridlines | Charts and Charting in Excel | |||
Adding x axis labels | Charts and Charting in Excel |