• Home
  • About Me
  • Contact Me

Data Cornering

Journey in work with data

  • Facebook
  • Twitter
  • LinkedIn

Data Cornering

  • Home
  • About Me
  • Contact Me
  • Facebook
  • Twitter
  • LinkedIn
Info

Popular Categories

Top PostsAll posts

gradient shade under the line chart in R, gradient area chart in R
DataViz R

How to create gradient shade under the line chart in R

Here is how to create a vertical gradient shade under a line chart in R. It is a trickier task than using the…

by Janis Sturis July 28, 2022
mean by group in R, average by group in R
R

Mean by a group in R

month name from month number in R
R

How to get the month name from the number in R

quickly change the weight for all series in an Excel line chart
Excel

How to change weight for all series in an Excel line chart or do other formatting

Latest Posts

R script from CMD
CMD R

How to run R scripts from the Windows command line (CMD)

by Janis Sturis October 19, 2018
Excel VBA

How to fix it: Excel 2016 restarting immediately after opening xlsm file

by Janis Sturis October 17, 2018
Power BI Power Query

How to get LiveChat API data with Microsoft Excel or Power BI

by Janis Sturis October 14, 2018
Video
Excel PivotTable Video

How much you can do with PivotTable in 5 minutes?

by Janis Sturis October 13, 2018
Power Query

How to generate date and time interval list using Power Query

by Janis Sturis October 12, 2018
Data Visualization Excel

How to copy a sharp picture from Excel without blurry effect

by Janis Sturis October 11, 2018
Excel PivotTable histogram
Data Visualization Excel Statistics

Probably simplest and fastest way how to make a histogram in Excel

by Janis Sturis October 10, 2018
CMD

2 tips how to change Windows CMD looks

by Janis Sturis October 9, 2018
Windows

Do i really need Windows 10 search icon?

by Janis Sturis October 6, 2018

Posts navigation

Newer Newer Posts Page 1 … Page 22 Page 23

Categories

Reader PicksAll posts

gradient shade under the line chart in R, gradient area chart in R
DataViz R

How to create gradient shade under the line chart in R

Here is how to create a vertical gradient shade under a line chart in R. It is a trickier task than using the…

mean by group in R, average by group in R
R

Mean by a group in R

Here is how to calculate the mean by a group in R. If you are an Excel, user you might prefer to say…

month name from month number in R
R

How to get the month name from the number in R

There are multiple scenarios where you would like to get the month name from the number in R. Here are two solutions to…

quickly change the weight for all series in an Excel line chart
Excel

How to change weight for all series in an Excel line chart or do other formatting

If you have a line chart with a lot of series, it is time-consuming to format all of them separately. Here are a…

move Excel chart axis labels below or on top
Excel

How to move Excel chart axis labels to the bottom or top

Here is how to move Excel chart axis labels to the bottom or top of the chart. It is helpful modification if an…

glow effect in R plot, neon effect in R
DataViz R

How to add glow effect in R plot

The glow effect in the R plot might be one of those adjustments that someone uses rarely. Meanwhile, neon luminescence adds a special…

detect data types in R, check data type in R
R

How to detect data type in R and change it if necessary

Here is how to detect data type in R and change it when necessary. Further data manipulations may require checking of that. For…

stripchart in Excel, jitter chart in Excel
DataViz Excel

Stripchart in Excel, onedimensional scatter chart with or without jitter

Stripchart in Excel is a great way to compare data points between multiple categories. It might be with or without additional jitter. Jitter…

convert units in R
R

How to convert units in R like ft to m or lbs to kg

Here is a simple solution that helps to convert units in R and, in this case, feet to meters and pounds to kilograms.…

text labels on Excel scatter chart axis
DataViz Excel

How to add text labels on Excel scatter chart axis

By default, you can not add text labels on Excel scatter chart axis, but here is a workaround that allows you to do…

  • Copyright © 2022 Data Cornering
  • Powered by WordPress
  • Theme: Uku by Elmastudio
Follow me
  • Facebook
  • Twitter
  • LinkedIn