L
LB
I am trying to create mulitple bar charts on separate tabs within one
workbook. The bar charts contain data on our product as well as data for a
set benchmark. I have one master file with all the data I need to create the
charts (located in the same workbook as the charts). The problem I am
running into is the master file changes from month to month. Products are
added and removed every month so the products/data I need to chart fall in
differnt rows from one month to the next.
Using the layout of the master file below as an example, the file might have
contained 50 products last month, 52 products this month and next month it
might have 55 products. I might only need to graph 25 of the products in the
master file but becuse products are added and deleted, the products change
rows every month.
Is there a way to use the vlookup funtion to create bar charts? I think
there might be but I'm not sure how to do this using the chart wizard. Any
suggestions?
Product Benchmark Characterstic Product Benchmark
to be charted Value Value
Product A Benchmark A Char. 1 6.71 6.67
Product A Benchmark A Char.2 5.52 5.51
Product A Benchmark A Char. 3. 8.61 8.57
Product A Benchmark A Char. 4 6.96 6.93
Product A Benchmark A Char. 5 29.86 29.92
Product B Benchmark B Char. 1 16.03 15.63
Product B Benchmark B Char.2 3.32 3.53
Product B Benchmark B Char. 3. 1.88 1.88
Product B Benchmark B Char. 4 12.89 13.82
Product B Benchmark B Char. 5 12.23 8.00
Product B Benchmark B Char. 6 20.38 21.09
Product C Benchmark C Char. 1 5.14 5.75
Product C Benchmark C Char.2 0.00 0.15
Product C Benchmark C Char. 3. 3.09 3.18
Product C Benchmark C Char. 4 9.30 9.04
Product C Benchmark C Char. 5 21.56 17.85
Product C Benchmark C Char. 6 19.85 19.40
Product C Benchmark C Char. 7 1.06 2.65
Product C Benchmark C Char. 8 15.12 16.63
workbook. The bar charts contain data on our product as well as data for a
set benchmark. I have one master file with all the data I need to create the
charts (located in the same workbook as the charts). The problem I am
running into is the master file changes from month to month. Products are
added and removed every month so the products/data I need to chart fall in
differnt rows from one month to the next.
Using the layout of the master file below as an example, the file might have
contained 50 products last month, 52 products this month and next month it
might have 55 products. I might only need to graph 25 of the products in the
master file but becuse products are added and deleted, the products change
rows every month.
Is there a way to use the vlookup funtion to create bar charts? I think
there might be but I'm not sure how to do this using the chart wizard. Any
suggestions?
Product Benchmark Characterstic Product Benchmark
to be charted Value Value
Product A Benchmark A Char. 1 6.71 6.67
Product A Benchmark A Char.2 5.52 5.51
Product A Benchmark A Char. 3. 8.61 8.57
Product A Benchmark A Char. 4 6.96 6.93
Product A Benchmark A Char. 5 29.86 29.92
Product B Benchmark B Char. 1 16.03 15.63
Product B Benchmark B Char.2 3.32 3.53
Product B Benchmark B Char. 3. 1.88 1.88
Product B Benchmark B Char. 4 12.89 13.82
Product B Benchmark B Char. 5 12.23 8.00
Product B Benchmark B Char. 6 20.38 21.09
Product C Benchmark C Char. 1 5.14 5.75
Product C Benchmark C Char.2 0.00 0.15
Product C Benchmark C Char. 3. 3.09 3.18
Product C Benchmark C Char. 4 9.30 9.04
Product C Benchmark C Char. 5 21.56 17.85
Product C Benchmark C Char. 6 19.85 19.40
Product C Benchmark C Char. 7 1.06 2.65
Product C Benchmark C Char. 8 15.12 16.63