![]() Right click the Actual series, choose Chart Type from the pop up menu, and select a Line Chart subtype: Make a column chart with all of the data: ![]() Suppose your data looks like this (ignore the “height” column for now): If you have target and actual data for a set of product attributes, for example, you can make a column-line combination chart readily. ![]() When you have two series in a chart, and you want to show them using two different chart types, you have a broad array of choices. Please visit Bar-Line (XY) Combination Chart in Excel. It has been rewritten to take into account changes in how chart axes are treated in Excel 2007 and later versions of Excel. This vintage post was written with Excel 2003 in mind.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |