Hi everyone,
I would like to know how compare data with 2 bars rather than a bar and a line. One bar would represent the number of visits for a given company(first y axis) and the other bar would represent a monetary value(secondary y axis). I am able to compare the two with a bar representing the visits and a line representing the money. Is there anyway to use two different bars (of different colors)?
Thanks!!
May be this link will help?
http://peltiertech.com/Excel/Charts/...OnTwoAxes.html
oldchippy
-------------
If you are happy with the help you have received, please click the blue scales icon in the blue bar of the post.
Click here >>> Top Excel links for beginners to Experts
Forum Rules >>>Please don't forget to read these
Thanks for the quick response! I'm sure that site has what I need but I'm somewhat of a beginner at Excel and don't quite understand!
Hello there,
It would be better if you could provide a small zipped sample of your data you want to chart, then may be I can assist. Can't guarantee a solution, but it would help.
To post a zipped example, go to “My Documents” or wherever you have your file stored, right-click and “Send to > Compressed file”, then attach this zipped file to your post.
oldchippy
-------------
If you are happy with the help you have received, please click the blue scales icon in the blue bar of the post.
Click here >>> Top Excel links for beginners to Experts
Forum Rules >>>Please don't forget to read these
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks