Ÿ TheTextFontPropertyisavailableforalltextobjects,includingtitles,
axislabels,andtextyoucreateusingtheTexttoolonthechartwindow
toolbar.
Changingy-axisproperties
QuattroProautomaticallyadjuststhey-axisscaletofittherangeofvalues
plottedagainstit.YoucanchangetheHigh,Low,Increment,andNo.
(number)ofMinorsvaluestofine-tunethechartortozoominonaspecific
area.
Ÿ High—setsthehighestvaluedisplayedonthescale(ifyouenteravalue
thatislowerthanthevaluesinthedataseries,theplotforthevaluewill
appeartorunoffthetopofthechart)
Ÿ Low—setsthelowestvaluedisplayedonthescale(ifyouenteravalue
thatishigherthanthevaluesinthedataseries,theplotforthevaluewill
appeartorunoffthebottomofthechart)
Ÿ Increment—determinesthenumeric“distance”betweenmajory-axis
divisions.Y-axislabels,majortickmarks,andmajorgridlinesareplaced
atthesedivisions.
Ÿ No.ofMinors—specifiesthenumberofevenly-spacedminortickmarks
and/orminorgridlinesbetweenthemajory-axisdivisions.
Inadditiontoscalemodifications,youcansetthey-axistodisplayunitsora
logarithmicscale.
Secondaryy-axes
Youcanplotaseriesin2-Dbar,line,andvariancechartsonasecondary
y-axis.High-Lowchartsrestrictthisfeaturetothefifthseriesorgreater.You
maywanttodothis,forexample,whenthevaluesinoneseriesaremuch
largerorsmallerthanthoseinotherseries.Whenthereisawidevariation
betweenseries,they-axisscalerangecanbesolargethatsomeseriesare
barelyvisibleabovethex-axis.Ifyouplottheseriesthatdiffersmostonthe
secondaryy-axis,theprimaryy-axisadjuststoaccommodatetheother
series.
Youcanalsousethisfeaturewhenthedataisbasedonadifferentkindof
scale.Forexample,onaHigh-Low(open-close)volumechart,youcanplot
sharepricesontheprimaryy-axis,andthevolume(numberofstockstraded)
onthesecondaryy-axis.
Thesecondaryy-axiswillhavethesamepropertiesastheprimaryy-axis.
Presentingspreadsheetdatainachart
371
Pdf text searchable - search text inside PDF file in C#.net, ASP.NET, MVC, Ajax, WinForms, WPF
Learn how to search text in PDF document and obtain text content and location information
select text in pdf reader; pdf find and replace text
Pdf text searchable - VB.NET PDF Text Search Library: search text inside PDF file in vb.net, ASP.NET, MVC, Ajax, WinForms, WPF
Learn How to Search Text in PDF Document and Obtain Text Content and Location Information in VB.NET application
pdf text search; make pdf text searchable
Changingy-axisproperties
UsetheY-AxisPropertiesdialogboxtomodifythey-axis.Youcanchange
anyofthey-axisproperties,includingthewaythey-axisdisplaysunits.
Tochangethey-axisproperties
1 Selectachart.
2 ClickChart,Axes,PrimaryY-Axis.
3 Clickoneoftheappropriatetabs:
Ÿ Scale—selectstherangeofnumbersusedonthey-axis
Ÿ TickOptions—setsthestyleoftheshort,horizontallinesthat
separatedivisionsonthey-axis(therearefourtickstyles:None,Left,
Right,andAcross)
Ÿ Numericformat—letsyouchoosefromalargelistofformatsor
customnumericformats
Ÿ TextFont—setsthefontorfontsizeforthey-axislabels
Ÿ TextSettings—setstheshadowing,color,andfillstyleforlabels
Ÿ MajorGridStyleandMinorGridStyle—setsthenumberoflineson
they-axisandbetweenticks
Ÿ InQuattroProcharts,themethodyouusetoassignagridstyleissimilar
forthexandyaxes,otherthanthey-axisletsyouassignamajoranda
minorgridstyle.Ifyouwantinformationaboutassigningeithergridstyle,
see“Modifyingx-axisproperties”onpage366.
Ÿ Forinformationaboutchangingtickoptions,see“Changingx-axistick
options”onpage367.
Ÿ Foradescendingaxisscale,reversethehighandlowvalues.Toreturnto
thedefaultsetting,enabletheAutomaticcheckbox.
Showingunitsonthey-axis
Ifthenumbersdisplayedonthey-axisaregreaterthan1000,youcanadjust
thescaletodisplayonlytheunittitlealongthey-axis;forexample.by
selectingtheShowUnitsoption,display“Thousands”or“Millions”,
372
QuattroPro9:Chapter12
C# PDF Convert to Text SDK: Convert PDF to txt files in C#.net
NET project. Powerful .NET control for batch converting PDF to editable & searchable text formats in C# class. Free evaluation library
how to search text in pdf document; text searchable pdf
C# Create PDF Library SDK to convert PDF from other file formats
The PDF document file created by RasterEdge C# PDF document creator library is searchable and can be fully populated with editable text and graphics
search pdf documents for text; find text in pdf image
Toshowunitsonthey-axis
1 Selectachart.
2 ClickChart,Axes,PrimaryY-Axis.
3 ClicktheScaletab.
4 EnabletheShowUnitscheckbox.
(Disablethecheckboxtoturnthefeatureoff.)
5 Right-clickthetitle,andclickPropertiestochangethefont,color,orother
propertiesoftheunittitledisplayedalongthex-axis.
Scalingthey-axislogarithmically
Inalogarithmicallyscaledaxis,eachmajordivisionoftheaxisrepresents10
timesthevalueofthepreviousmajordivision.Thistypeofscaleisuseful
whenyouplotserieswithwiderangesinmagnitude.
Tocreateany-axislogarithmicscale
1 Selectachart.
2 ClickChart,Axes,X-Axis.
3 ClicktheScaletab.
4 EnabletheLogbutton.
Settingazerolineonthey-axis
Thisturnsyourchartintoavariancechart.Avariancechartrequiresvalues
belowzeroinoneofthedataseries.
Forinformationaboutsettingavarianceline,see“Workingwithvariance
charts”onpage336.
Presentingspreadsheetdatainachart
373
Asampleofachart
usingalogarithmic
scale.
VB.NET Image: Robust OCR Recognition SDK for VB.NET, .NET Image
for VB.NET provides users fast and accurate image recognition function, which converts scanned images into searchable text formats, such as PDF, PDF/A, WORD
how to select text in pdf image; convert a scanned pdf to searchable text
VB.NET PDF Convert to Text SDK: Convert PDF to txt files in vb.net
keeping original layout. VB.NET control for batch converting PDF to editable & searchable text formats. Support .NET WinForms, ASP
how to make a pdf document text searchable; pdf find text
Changingthenumericformatofthey-axis
Thisprocedureallowsyoutochangethetypeofnumericformatdisplayedon
they-axis.Forexample,youcandisplaydatausingcurrencysymbolsor
percentages.
Tochangethenumericformatforthey-axisscale
1 Selectthechart.
2 ClickChart,Axes,PrimaryY-Axis.
3 ClicktheNumericFormattab.
4 Selectaformatoptionfromthefollowingoptions:
Ÿ General—displaysnumbersasentered
Ÿ Number—displaysnegativeandpositivevalues,includingdecimals
Ÿ Currency—displaysnumbersusingcurrencysymbols
Ÿ Scientific—displaysnumberswithscientificnotation,allowingonly
onedigitintheintegerportionofthenumber
Ÿ Fraction—displaysnumbersasfractions
Ÿ Percent—displaysnumbersaspercentages
Ÿ Date—displaysnumbersasdatevaluesintheformatyouchoose
Ÿ Time—displaysnumbersastimesintheformatyouchoose
Ÿ Custom—letsyouchoosefromalistofformatsyouhavepreviously
created
Addinganothery-axistocharts
Asecondaryy-axisdisplaysontherightsideofthechart,whiletheprimary
y-axisdisplaysontheleft.QuattroProscalesthesecondaryy-axisto
accommodatethehighestandlowestvaluesintheseries.Thesecondary
y-axishasthesamepropertiesastheprimaryy-axis.
Toplotseriesonthesecondaryy-axis
1 Selectthechart.
2 Right-clickthechartseriesmarker,thenclickLineSeriesProperties.
3 ClicktheSeriesOptionstab.
4 EnabletheSecondarybuttonintheY-Axissection.
374
QuattroPro9:Chapter12
C# HTML5 Viewer: Load, View, Convert, Annotate and Edit Word
C# users can convert Convert Microsoft Office Word to searchable PDF online, create multi empowered to add annotations to Word, such as add text annotations to
select text in pdf; search pdf files for text programmatically
Online Convert PDF to Text file. Best free online PDF txt
PDF document conversion SDK provides reliable and effective .NET solution for Visual C# developers to convert PDF document to editable & searchable text file.
how to make pdf text searchable; search a pdf file for text
Customizinglegendsandtitles
Youcancustomizebothchartlegendsandcharttitles.Youcanalsoadda
subtitletoachartandatitletothechart’slegend.
Understandinglegends
Alegendboxappearsassoonasyoudefinealegendseriesinall2-D(except
pie,column,anddoughnut)charts,andinsome3-Dcharts.Formore
informationon3-Dchartslabels,see“Modifyinga3-Dchartlegend”onpage
359.
Whenyouaddordeleteadataseries,thelegendseries(ifoneisdefined)
doesnotchangeautomatically.Ifyouinsertordeleteaseriesfromachart,
youalsohavetoeditthelegendaccordingly.
Ifyouaddonadditionalseries,anotherbar,linemarker,orareaboundary
pointisaddedateachx-axisdivision.Ifyouseenewx-axisdivisionswithout
labelsafteryouaddaseries,thismeansthenewserieshasagreaternumber
ofdatapointsthantheotherseriesinthechart.Selecttheseriesagain,and
assignaselectionthathasthecorrectnumberofvalues.
Youcanalsoenterlegendlabeltext(orlabelcellcoordinates)forindividual
seriesbyright-clickingtheseriesandclickingProperties.
Understandingcharttitles
Youcancreateatitleandsubtitleforanynumericcharttype,butnotfor
bulletchartsorblankcharts.Youcanalsousethisoptiontoplacetitleson
thechartaxes.On2-Dcharts,youcanaddtitlesforthex-axis,theprimary
y-axis(theleft,orY1axis)andforasecondaryy-axis(theright,orY2axis).
3-Dchartswillnotdisplaysecondaryy-axistitles.Youcanchangethetitle
andsubtitlepropertiesincludingthespelling,fontsize,andtype.Youcanedit
themaintitleandsubtitletextdirectlyonthechart,orchangethetitleor
subtitleintheTitlesdialogbox.
Insteadoftypinginatitle,youcanreferencethecellthatcontainsthe
appropriatetextusingthetitlebox.Justtypethecellreferenceprecededbya
backslash(\).Forexample,type\G8inthetitleboxdisplaysthetextincell
G8asthetitle.Youcanuse@STRINGandotherstringspreadsheet
functionswithnumericformulastocreatedynamictitlesthatchangealong
withyourdata.Forexample,enteringthefollowingformulaincellG8creates
astringthatdisplaystheaverageofcellsC5..C9aftertheequalsign:
+"Five-YearMileageAverage=“&@STRING(@AVG(C5..C9),0)
Presentingspreadsheetdatainachart
375
VB.NET Create PDF from Text to convert txt files to PDF in vb.net
Best VB.NET adobe text to PDF converter library for Visual Studio .NET project. Batch convert editable & searchable PDF document from TXT formats in VB.NET
search pdf for text in multiple files; how to select text in pdf and copy
C# Create PDF from Text to convert txt files to PDF in C#.net, ASP
Visual Studio .NET project. .NET control for batch converting text formats to editable & searchable PDF document. Free .NET library for
pdf searchable text converter; search pdf files for text
Addingtitlesandlabelstocharts
QuattroProletsyouaddtitlesandsubtitlestocharts.Italsoletsyouadd
labelstobarsordatapointsinachart.
Toaddtitlestoachart
1 Right-clickthechart,thenclickTitles.
2 Typetextintheappropriateboxes.
Toaddlabelstobarsordatapointsonachart
1 Enteraseriesoflabelsintothecells(ifsuitablelabelsdonotalready
exist).
2 Right-clickthebar,line,orareathatrepresentstheseries,thenclick
SeriesProperties.
TheSeriesOptionspropertyisautomaticallyselected.
3 ClickthePointerbuttontotherightoftheLabelSeriesbox,thenselect
thecellsonthenotebooksheetthatcontainthelabels.
Ÿ Thecellsyouspecifyasthelabelseriescancontaintextordata.For
example,ifyouassignthesamecellstothedataseriesandthelabel
seriesofabarchart,QuattroProplacesalabelwiththeactualdatavalue
overeachbarintheseries.
Changingtitleandsubtitleproperties
Asingletextboxenclosesthecharttitleandsubtitle.Whenyoucreatea
title,youdonotseethetextboxbecauseitsfillstyleandboxtypearesetto
Nonebydefault.Youcanchangethetitleandsubtitlepropertiessuchas
alignment,font,color,box,andfill.Thecharttitle’sAlignmentpropertyalso
setsthealignmentforthesubtitle.
Tochangetitleorsubtitleproperties
1 Selectthechart.
2 ClickChart,Titles.
3 ClickoneofthefollowingChartTitletabs:
Ÿ Alignment—positionsthetitleleft,right,orcenter
Ÿ TextFont—setsthefontface,size,orappearance
376
QuattroPro9:Chapter12
VB.NET Create PDF from Word Library to convert docx, doc to PDF in
Export all Word text and image content into high quality Professional .NET PDF batch conversion control. Easy to create searchable and scanned PDF files from
search multiple pdf files for text; pdf find highlighted text
VB.NET Create PDF from PowerPoint Library to convert pptx, ppt to
PDF, VB.NET convert PDF to text, VB.NET multiple pages PowerPoint to fillable and editable PDF documents. Easy to create searchable and scanned PDF files from
how to select all text in pdf; search pdf for text
Ÿ TextSettings—setsthefillsettings,color,andbackgroundcolorifa
patternorwashhasbeenselected
Ÿ BoxSettings—setsthetypeofborderforthetitlefield
Ÿ FillSettings—setsthefillandbackgroundcolorsforthetitlefield
Ÿ Youcaneditthemaintitleandsubtitletextdirectlyonthechart,or
changethetitleorsubtitleintheboxsoftheChart,Titlesdialogbox.
Ÿ TheTextSettingsPropertyisavailableforalltextobjects,includingtitles,
subtitles,axislabels,andtextyoucreateusingtheTexttoolontheChart
toolbar.Wash,Bitmap,and3-Doptionsarenotavailableforthey-axisand
y2-axisin2-Dand3-Dcharttypes,andforthex-axisinrotatedchart
types.
Positioningthechartlegend
Youcanpositionalegendattherightsideofthechartoratthebottomofthe
chart.Youcanalsochoosenottodisplaythelegend.
Topositionalegend
1 Selectthechart.
2 ClickChart,Legend.
3 ClicktheLegendPositiontab,thenclickoneofthefollowingicons:
Ÿ None—hidesthelegend
Ÿ Bottom—displaysthelegendonthebottomofthechart
Ÿ Right—displaysthelegendontherightofthechart
Ÿ Youcanalsomanuallydragthelegendtoanewlocationonthechart.
Adjustinglegendpropertiesandx-axisseries
Legendlabelsappearinthelegendboxof2-Dcharts(exceptpieandcolumn
charts),andinsome3-Dcharts.Inmost3-Dcharts,legendlabelsappear
alongthez-axis.Inmultiplecharts,legendlabelsappearas“titles”ofthe
sub-chartsthatrepresenteachseries.
Presentingspreadsheetdatainachart
377
Toadjustthelegendandx-axisseries
1 Selectthechart.
2 ClickChart,Series.
3 ClickthePointerbuttontoedittheLegendbox.
RepeatthissteptoedittheX-AxisSeriesbox.
4 HolddowntheCTRLkey,thenpointtothelabelforeachseries,inorder.
Tooverridealegendlabel
1 Selectthechart.
2 ClickEdit,Chart.
3 Right-clickthechartseriesmarkerandclickSeriesProperties.
4 Typethelabeltextorenterthelabel’scelladdressprecededbyaslash
(forexample,\A:E5)intheLegendbox.
Modifyingthelegend’sappearance
Youcanchangehowthelegendappearsonthechart.
Tocustomizethelegend
1 Selectthechart.
2 ClickChart,Legend.
3 Clickoneormoreofthefollowingtabs:
Ÿ TextFont—setsthefontface,size,orappearance
Ÿ TextSettings—setsthetextcolorandfill
Ÿ BoxSettings—setsthetypeofborderforthelegend
Ÿ FillSettings—setsthefillandcolorofthelegendbox
Ÿ ForinformationaboutchangingfillandcoloroftextontheTextSettings
tab,see“Changingfillandborderproperties”onpage383.
Ÿ Youcanalsodouble-clickanyseriesboxtoedittheseries.
378
QuattroPro9:Chapter12
Addinggraphicstocharts
YoucanaddclipartandgraphicstoQuattroProcharts.Youcandrawdifferent
shapestoemphasizeaspectsofthechart,orinsertanexistinggraphic.
Understandingtheaspectratioofcharts
Dependingontheintendedpurposeoftheslides,adjustingtheaspectratioof
chartssetstheproportionsofthechartinrelationtothewaythechartcanbe
viewed.Forexample,achartcanappearinafullscreenformat(suitablefor
addingtoaslideshow)orasafloatingchart.Youcanalsochooseanaspect
ratiosuitablefor35mmslideformats.Asachartmovesfromonedisplayto
another,itsoverallshapesometimesshifts.Youcancontrolthesechangesby
settingachart’saspectratio.Ifyouwanttoaddgraphicstoachart,itis
importanttosettheaspectratiosothatnodistortionoccurstothegraphicsif
adifferentaspectratioisselectedlater.
Drawingobjectsonachart
QuattroProincludesadrawingtoolbarthatcontainsdrawingtoolsyoucan
usetocreatearrows,circles,rectangles,andothergraphiceffectsonyour
charts.Thisisusefulforhighlightingcertainaspectsofdatarepresentedon
yourcharts.
Thistoolbarincludesasetofquick-accesstoolsandbuttons:
Ÿ Cutbutton
,Copybutton
,andPastebutton
transfer
objectstoandfromtheWindowsClipboard
Ÿ Importbutton
importsafile
Ÿ SelectionToolbutton
switchestoselectionmodewhenyoufinish
withadrawingtool
Ÿ Texttool
createstextboxes
Thefollowingdrawingtoolscreateshapes:
Linetool
Arrowtool
Polylinetool
Freehanddrawingtool
Polycurvetool
Presentingspreadsheetdatainachart
379
Polygontool
Rectangletool
RoundedRectangletool
Ellipsetool
Ÿ Formoreinformationaboutdrawingobjects,see“Addinggraphicsto
spreadsheets”onpage393.
Ÿ Maximizethechartwindowtomakedrawingeasier.
Insertinggraphicsinyourcharts
QuattroProletsyouaddclipartorothergraphicstothechartsyoucreate.
Theprocedureforaddingtheseobjectstochartsisthesameasifyouwere
addingthemtothespreadsheet.Formoreinformationaboutaddinggraphics
toyourcharts,see“Designingborders,lines,andshapes”onpage404.
Adjustingtheaspectratioofcharts
Tosavetime,choosetheaspectratioforyourfinaloutputbeforeyoubeginto
changepropertiesordrawobjects.A35mmslidehasdifferentproportions
thanan8.5x11-inchsheetofpaper,forexample.Agraphanditslabelsmay
lookrightwhentheaspectratioissetto35mmscreenslide,buteverything
mayneedtoberesizedwhentheaspectratioischangedtoprinterview.The
followingexamplesshowthesamechartviewedwithdifferentaspectratio
options:
380
QuattroPro9:Chapter12
TheFloatingChart
aspectratioviewofa
chart.
Documents you may be interested
Documents you may be interested