ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)
-   -   How do I graph the following? (https://www.excelbanter.com/charts-charting-excel/122279-how-do-i-graph-following.html)

Liz Merrell

How do I graph the following?
 
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!


William Horton

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!




All times are GMT +1. The time now is 11:45 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com