| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Don't want to show X axis labels.
I have a chart that shows 07 months as the x axis labels. My table has labels
for Jan 07 thru Dec 07. There isn't any data for Aug 07 thru Dec 07. Can I make the chart not show those labels. Then when someone adds the data for those months it automatically updates the chart...ie add the labels for the following months as they are inputted? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Don't want to show X axis labels.
Use dynamic ranges for the X and Y values of each series:
http://peltiertech.com/Excel/Charts/...umnChart1.html http://peltiertech.com/Excel/Charts/Dynamics.html - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "patrick" wrote in message ... I have a chart that shows 07 months as the x axis labels. My table has labels for Jan 07 thru Dec 07. There isn't any data for Aug 07 thru Dec 07. Can I make the chart not show those labels. Then when someone adds the data for those months it automatically updates the chart...ie add the labels for the following months as they are inputted? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Don't want to show X axis labels.
thanks, that works well.
"Jon Peltier" wrote: Use dynamic ranges for the X and Y values of each series: http://peltiertech.com/Excel/Charts/...umnChart1.html http://peltiertech.com/Excel/Charts/Dynamics.html - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "patrick" wrote in message ... I have a chart that shows 07 months as the x axis labels. My table has labels for Jan 07 thru Dec 07. There isn't any data for Aug 07 thru Dec 07. Can I make the chart not show those labels. Then when someone adds the data for those months it automatically updates the chart...ie add the labels for the following months as they are inputted? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Y-axis labels | Excel Discussion (Misc queries) | |||
| Y Axis Labels | Charts and Charting in Excel | |||
| X-axis labels | Charts and Charting in Excel | |||
| Chart problem: values in column A don't show as labels on x-axis | Excel Discussion (Misc queries) | |||
| how to put x axis values in the chart instead of x axis labels | Charts and Charting in Excel | |||
Linear Mode
