Hi folks
I would like to know if it is possible to make a graph exactly like this in excel??
help.png
please help asap
Hi folks
I would like to know if it is possible to make a graph exactly like this in excel??
help.png
please help asap
Last edited by AnniC; 03-06-2014 at 10:18 AM. Reason: update title
Your post does not comply with Rule 1 of our Forum RULES. Your post title should accurately and concisely describe your problem, not your anticipated solution.
Use terms appropriate to a Google search. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will be addressed according to the OP's experience in the forum: If you have less than 10 posts, expect (and respond to) a request to change your thread title. If you have 10 or more posts, expect your post to be locked, so you can start a new thread with an appropriate title.
To change a Title on your post, click EDIT then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.
(This thread should receive no further responses until this moderation request is fulfilled, as per Forum Rule 7)
This is about the best I can do to get it really close.
Make contributors happy, click on the "* Add Reputation" as a way to say thank you.
Sam Capricci
This one is closer...
To Forum moderators
I apologise for my lack of clarity as to the title of my post.
As i am not an expert in the field of excel i was unsure as to what to call the post.
Title is ok now!
Sambo Kid
Can you pls upload the sample sheet again?
Regards
Fotis.
-This is my Greek whisper to Europe.
--Remember, saying thanks only takes a second or two. Click the little star * below, to give some Rep if you think an answer deserves it.
Advanced Excel Techniques: http://excelxor.com/
--KISS(Keep it simple Stupid)
--Bring them back.
---See about Acropolis of Athens.
--Visit Greece.
Cool, thanks Fotis, and BTW i did start a post on improvements/suggestions.
AnniC, based on your new title I'm not sure if this gets you close enough but see what you think.
Last edited by Sam Capricci; 03-06-2014 at 09:32 AM.
Your image appears to show a chart that really distorts the data.
The spacing for values between 0 and 50 consumes the same space as that showing 90 to 100. Surely they should be proportional?
Basically all i am looking for is a graph similar to the one in the OP and also that Sambokid posted.
the data i have is just a volume/intensity relationship for in exercise.
Sambo kid how would i go about compiling the graph you sent me with a combi chart
What I did just involved a lot of formatting, I deleted the x and y axis and substituted yours as columns A and B. Then changed the bar colors and the background colors to roughly match yours.
Beyond that I can't answer more for now because I have a 2 hour meeting I'm going into shortly. If you have any more questions I can revisit when I get out of the meeting.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks