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

How to make a fluent chart for merged cells? 1
Replacing numeric X-axis labels with corresponding text string 2
VBA set thick borders around non empty cells in range 0
Auto Row Height with Wrapped Text in Merged Cells Problem 3
Automatically color merged cells 1
Insert Row and keep merged cells formatting 1
Chart incorrectly displays time of day on x-axis 3
Chart for merged cells as source data 1

Top