ZDNet reader seeks help with Excel

Summary: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.

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 rbagby2@gmail.com.

Topics: Big Data

About

David Berlind was fomerly the executive editor of ZDNet. David holds a BBA in Computer Information Systems. Prior to becoming a tech journalist in 1991, David was an IT manager.

Kick off your day with ZDNet's daily email newsletter. It's the freshest tech news and opinion, served hot. Get it.

Related Stories

The best of ZDNet, delivered

You have been successfully signed up. To sign up for more newsletters or to manage your account, visit the Newsletter Subscription Center.
Subscription failed.