| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
problem in chart x axis while values are in merged cell
I have values of 12 months in row 2. I have merged 2 cells and put the value
in 12 such merged cells. Now how can I show 12 divisions in the chart x axis as it automatically shows 24 divisions? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
problem in chart x axis while values are in merged cell
Get rid of the merged cells.
Look at the archives of this group to see countless reasons to avoid them (unless there is no alternative). -- David Biddulph "narnimar" wrote in message ... I have values of 12 months in row 2. I have merged 2 cells and put the value in 12 such merged cells. Now how can I show 12 divisions in the chart x axis as it automatically shows 24 divisions? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
problem in chart x axis while values are in merged cell
Thank you.
"David Biddulph" wrote: Get rid of the merged cells. Look at the archives of this group to see countless reasons to avoid them (unless there is no alternative). -- David Biddulph "narnimar" wrote in message ... I have values of 12 months in row 2. I have merged 2 cells and put the value in 12 such merged cells. Now how can I show 12 divisions in the chart x axis as it automatically shows 24 divisions? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| X-axis values in xlLine chart problem | Charts and Charting in Excel | |||
| Chart problem: values in column A don't show as labels on x-axis | Excel Discussion (Misc queries) | |||
| Chart problem: values in column A doen't show 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 | |||
| How do I change X-Axis values in a chart with 2 Y-Axis? | Charts and Charting in Excel | |||
Linear Mode
