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)
Never use Merged Cells in Excel
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