Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
log log charts in excel
Can somebody please advise me how I may chart data using log scales on either
or both axes? Thanks |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
log log charts in excel
Format Axis/ Scale tab
-- David Biddulph "Dave P" <Dave wrote in message ... Can somebody please advise me how I may chart data using log scales on either or both axes? Thanks |
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
log log charts in excel
Hi Thanks for the response, however this only allows it on the vertical
axis.... what about the horizontal axis? Thanks Dave P "David Biddulph" wrote: Format Axis/ Scale tab -- David Biddulph "Dave P" <Dave wrote in message ... Can somebody please advise me how I may chart data using log scales on either or both axes? Thanks |
#4
Posted to microsoft.public.excel.charting
|
|||
|
|||
log log charts in excel
Same.
If you don't have that option available, it's probably because you've got the wrong Chart Type. If you are using a Line Chart, change it to XY (which can still do lines, with our without marker points). The Chart Types are very misleadingly named. Many people end up choosing a line chart when what they need is XY. -- David Biddulph "Dave P" wrote in message ... Hi Thanks for the response, however this only allows it on the vertical axis.... what about the horizontal axis? Thanks Dave P "David Biddulph" wrote: Format Axis/ Scale tab -- David Biddulph "Dave P" <Dave wrote in message ... Can somebody please advise me how I may chart data using log scales on either or both axes? Thanks |
#5
Posted to microsoft.public.excel.charting
|
|||
|
|||
log log charts in excel
Hi Dave,
Sounds like you are using a line chart. Change it to an XYscatter and you can apply log scale to either axes. HTH Martin "Dave P" wrote in message ... Hi Thanks for the response, however this only allows it on the vertical axis.... what about the horizontal axis? Thanks Dave P "David Biddulph" wrote: Format Axis/ Scale tab -- David Biddulph "Dave P" <Dave wrote in message ... Can somebody please advise me how I may chart data using log scales on either or both axes? Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
link excel charts to web pages and update charts automatically | Charts and Charting in Excel | |||
Charts - How to have multiple charts share a legend. | Charts and Charting in Excel | |||
Charts created in Excel 2003 are not showing up in excel 2007 | Charts and Charting in Excel | |||
interactive charts for stacked bar charts | Charts and Charting in Excel | |||
Matching the colors Column Charts and Pie Charts | Charts and Charting in Excel |