A data series may not be plotted as expected in a combination chart in Excel 2007

Article translations Article translations
Article ID: 928987 - View products that this article applies to.
Expand all | Collapse all


You have a combination chart that contains a data series in a Microsoft Office Excel 2007 workbook. In this case, the data series may not be plotted as expected. For example, only one point of the data series may be plotted in the chart.


This issue may occur when the data series is plotted on the secondary axis.


To work around this issue, move the data series to the primary axis. To do this, follow these steps:
  1. Right-click the data series in the chart, and then click Format Data Series.
  2. Click Series Options.
  3. Click Primary Axis under Plot Series On, and then click Close.


For more information about a combination chart, follow these steps:
  1. Click Microsoft Office Excel Help, or press F1.
  2. Type combination chart in the Search box, and then click Search.


Article ID: 928987 - Last Review: October 15, 2007 - Revision: 1.2
  • Microsoft Office Excel 2007
kbtshoot kbchart kbformat kbprb kbexpertisebeginner KB928987

Give Feedback


Contact us for more help

Contact us for more help
Connect with Answer Desk for expert help.
Get more support from smallbusiness.support.microsoft.com