Lo All,
Attached is a screenshot of a chart I built but am for some reason the latter part of the series seems to be off a little. The blue lined series "Total Leads" is the series in question. As you can see for Qtrs 1 & 2 the chart is inline but for 3 & 4 it has shifted over one. Any help on how to correct for this?
ExcelComboGraphHelp.png
At further inspection, it seems they're all a little off. Hmmm...been playing with format options and can't get the sucker to line up...
Difficult to say much based on a picture. A sample file uploaded to the forum would be better (go advanced -> manage attachments -> upload attachment) I would guess that it has to do with the category x axis data for the two chart types not matching up. Try deleting the blank rows between the "blocks" in the line chart series.
Originally Posted by shg
You do not have enough data points in your line series in order to make the line data points align.
Could had sworn I replied. This worked, Andy. Thank you good sir. Did the rep I originally added populate for ya?
Reps received, thanks.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks