ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)
-   -   Create semi-log plot for percentage (https://www.excelbanter.com/charts-charting-excel/61454-create-semi-log-plot-percentage.html)

galgocid

Create semi-log plot for percentage
 

Good morning,

I have exhausted myself searching the internet for a way to create this
graph. I am really hoping that someone on this forum will help me.
:confused:

I am trying to make a (reverse??) semi-log plot with the y-axis to
display 0.9, 9, 99, 99.9, 99.99%. On the x-axis I want concentrations
of 0.0, 0.01, 0.05, 0.10, 0.25.

I have used the scatter plot with the logarithmic funchtion
selected...but that gives me 10,100,1000....I can seem to figure out
how to get it to do what I need.

Thank you in advance to anyone who replies!

galgocid


--
galgocid
------------------------------------------------------------------------
galgocid's Profile: http://www.excelforum.com/member.php...o&userid=29814
View this thread: http://www.excelforum.com/showthread...hreadid=495189


Tushar Mehta

Create semi-log plot for percentage
 
You can simulate the effect. See
Flexible Log Scale
http://www.tushar-
mehta.com/excel/newsgroups/flexible_log_scale/index.html

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions

In article ,
says...

Good morning,

I have exhausted myself searching the internet for a way to create this
graph. I am really hoping that someone on this forum will help me.
:confused:

I am trying to make a (reverse??) semi-log plot with the y-axis to
display 0.9, 9, 99, 99.9, 99.99%. On the x-axis I want concentrations
of 0.0, 0.01, 0.05, 0.10, 0.25.

I have used the scatter plot with the logarithmic funchtion
selected...but that gives me 10,100,1000....I can seem to figure out
how to get it to do what I need.

Thank you in advance to anyone who replies!

galgocid


--
galgocid
------------------------------------------------------------------------
galgocid's Profile:
http://www.excelforum.com/member.php...o&userid=29814
View this thread: http://www.excelforum.com/showthread...hreadid=495189




All times are GMT +1. The time now is 09:47 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com