I really hope someone can help me with this as it's driving me crazy. I have a chart in Excel which is based on a series of dynamic named ranges. When I update the source data, the table extends and the chart with it. I have this system in place for a number of charts which all work fine but this one is giving me grief for some reason.
The problem is that although the range is extending and the chart is linking to the correct data, the x axis labels don't seem to be showing after a certain point. I read somewhere that this may be linked to the axis format. I have date values in there which I have set to show as text as the formatting looked better. The odd thing is if I change to a date axis, the axis is fine but then I lose some of my data from the same point!
I tried changing the chart to use a static data range for the axis, rather than the named range but that didn't help, yet when I create a new chart with a static range it looks fine. If I delete all of the lines from the combo chart and just leave the bars in that also fixes it but I need the lines in there.
If anyone has any ideas on how to fix this please let me know as I really can't imagine what is wrong with it!