View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.charting
William Horton William Horton is offline
external usenet poster
 
Posts: 96
Default How do I graph the following?

Try either a column or a line chart.

Put your business components down the left side of the data as rows. Put
your weeks going across as columns. The data will be the data. Play around
with the chart options/setup using this and you should be able to get what
you want.

Hope this helps.

Bill Horton

"Liz Merrell" wrote:

Weekly data for 6 business components, where each week, the data could
be up or down. So, i'd like to see a 'build' for 4 weeks in a month,
but the values should not be added, simply the value of the week over
time. Thanks!