Plotting second value over bar in bar chart

[sparkyp]

Hello,

We are using the Visual Studio version of CR, and are looking to upgrade to the Developer edition. Can anyone tell me if it is possible to plot a second data series on a bar chart that appears as a cross (or anything!) over the bars. These should also be using the same axis as the bars as the crosses are showing, (for example) the previous week's sales, and the bars this week's sales. I've drawn a little example below.

Thanks for any help,

- Mark
[tt]
_
| _ | |
| | | X | |
| |X| _ | |
| | | | | |X|
|----------------
[/tt]

 

[lbass]

What are your "on change of" fields and your summary fields?

-LB

 

[sparkyp]

Hi,

Thanks for your reply. We currently use a table with four columns:

On change of: Day
Show values: A, B, C

There are no summary values - the table has five rows - one per day of the week.

We want to show values A and B stacked in one bar, and C as a point (cross, circle or something) over the bar.

Thanks for your help.

 

[lbass]

I am afraid that your version might not have the same capacity as 11.0, but in 11.0 you can create a stacked bar chart and then select one section of the riser->right click->series options->show selected series as line. Then select the marker on the line->right click->format series marker->fill->set it to "transparent" and then go to the border tab and select a color for the border of the marker. Setting the marker fill to transparent also makes the line transparent.

-LB

 

[sparkyp]

lbass,

Thanks very much. I think we are going to need to upgrade - we're going to try the evaluation version of the Developer Edition.

Cheers,

- Mark