|
RE: How do I change the bar chart to scatter format?
|
|
By changing the data layout and
using stacked columns instead of clustered you can get the
target markers to align with each column.
|
With 3 data series plotted as
a clustered column chart and 3 more plotted as line series the
line markers are all plotted central to the column cluster.
You can not use the xy
scatter chart instead of lines as the combination is not
permitted.
|
|
|
|
By altering the layout of the
data and changing the column chart to be stacked instead of
clustered you can get the line marker to be aligned over each
column.
Note the use of empty columns
A and E in the data sheet.
|
|
|
You can further enhance the
look by setting the Gap Width to zero.
The order of the legend can
also be changed by reordering the information in the datasheet.
|
|
|
|