Are you an Excel expert? ZDNet reader Dick Bagby wrote to me for help:
I keep weekly fiscal performance data on a histogram chart in Excel. Because there are several years of data, I would like to color code the columns of each year differently for a variety of reasons. In addition (but less importantly) I have 2 major sources of data for each column so it would be helpful if I could have for instance: Weekly data for year 1 would be shown in red with those columns shown in 2 shades of red indicating the contribution of source 1 and source 2. Year 2 might be in blue with each weekly column in dark and light blue depending on the source of the data.....There must be dozens and dozens of people that have this type of data they want to share with others in a more readable from than just having black columns with a legend at the bottom of the chart.....I will be most appreciative if you can point me to a person or a publication that will help me.
Use the comments section below if you want others to see your advice or if you can reach Dick at email@example.com.