![]() The bars increase in value from left to right, while the line values increase bottom to top. Right click on the Actual series, choose Chart Type, select the line with markers subtype. Here’s a new, simpler version of that tutorial. Long ago I wrote a tutorial on Bar-Line Combination Charts on my web site, but that’s a complicated example. What if you want to use horizontal bars? Perhaps the attribute labels are too long to make good category labels along the horizontal axis. 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 |