How do I change the bar chart to scatter format?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have an interesting problem. I need to display 3 years worth my data in
bar charts and overlay 3 years worth of target data in scatter format. For
example, I would have the following as bars:
2003 34%
2004 37%
2005 43%
then the following would be the targets, let's say as diamonds above the bars:
2003 38%
2004 40%
2005 45%

Line graphs with bar charts won't do this because they center the diamond on
my series, i.e. my diamonds are on top of each other.

I am trying to communicate that we are closing the gap towards our yearly
set targets.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top