How do I create a mixed line/bar graph with one datapoint?

[Galena1]

Ok, so here's the trick:

I know how to create combo or mixed graphs with line/bars on single axis, and secondary axis. I even know how to do mixed stacked and unstacked columnar charts...

But how do you depict in single view graph

a single bar (1 datapoint) with a single line (upper control limit e.g. target).?

And I don't want to to use shapes to draw the target line.

I want the target line to be automatically plotted by Excel...

Anyone?

Thanks!

 

[Steve=True]

Nice one Teylyn.

 

[teylyn]

How to do it with Error Bars:

- Add the cell as a new data series
- select the new data series and change the chart type to XY Scatter chart, line with markers. This will send the new data series to the secondary axis and will show a single data point marker on the chart.
- format the secondary Y axis to the same scale as the primary, then format it to show no line, no tick marks, no labels.
- format the secondary X axis to be min = 0 and max = 1. This will show the data point at the rightmost position in the chart. Format the axis to have no line, no tick marks, no labels.
- add error bars to the data point via Layout > Error bars > Error bars with Standard Error
- select and delete the vertical error bars
- format the X error bars to be "Minus" and to have an error amount of "Percentage" with "100%"
- format the X error bars with line color and line width of your preference.
- format the XY chart series to have no marker.

Done.