problem in chart x axis while values are in merged cell

N

narnimar

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?
 
D

David Biddulph

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).
 
N

narnimar

Thank you.

David Biddulph said:
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).
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

PowerPivot How to chart with contiguous time axis? 0
Doughnut Chart linked with the slicer in the pivot table 0
How to make a fluent chart for merged cells? 1
if statement with vlookup 1
Trendline Not Appearing In Chart Problem ? 0
Scatter charts for name with two values 0
Replacing numeric X-axis labels with corresponding text string 2
Make Y-axis values correspond to x- axis value 1

Top